Multi-select Dropdowns

How to create multi-select dropdowns in Google Sheets

Important notes:
* Don’t run the function manually, it will fail.
* Make sure the row and column in the IF() statement match the cell/range you want to include the dropdowns
* The red triangle at the top-right of the validation cannot be removed

Sheet (to copy from File then “Make a copy”)

function onEdit(e){
if (e.range.rowStart != 2 || e.range.columnStart != 3) return;
if (!e.value || !e.oldValue){}
e.range.setValue(e.oldValue + “, ” + e.value);

Connect with me:
• Twitter @FarrisSpencer
• Google Product Expert

Leave a Reply

Your email address will not be published. Required fields are marked *