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”)
https://docs.google.com/spreadsheets/d/1LCw9F_4iWi54AlnRL0issiwX6jeJ2smmVMGCgEU1JZQ/edit#gid=0

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

Connect with me:
• spencer.farris@gmail.com
• spencerfarris.me
• www.linkedin.com/in/spencer-farris/
• Twitter @FarrisSpencer
• Google Product Expert support.google.com/docs/profile/12305

Leave a Reply

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