How to create a multiple-selection drop-down in google sheet

Learn how to create multiple-selection drop-downs in Google Sheets using Apps Script.

Upon your request, I updated the code to help create multiple-selection drop-downs in multiple columns and sheets. Get the new code:

[EnglishWingMan]

Hi Joseph, do you have the old code that relates to this video? I can't work out how to use the new code for my sheet. Thanks!

[rahuuuuull]

Hey Joseph! Thank you so much for sharing this video and the sheet. It was very helpful for me.

[shirajbaidya]

Hi joseph, your link to the code is expired.

[Wasnotmeforsure]

Hello Joseph
I followed your steps but still allows for only one selection per cell.
Is anyone else facing this issues?

Also, for multiple column would it work if we just added the same code underneath and change the DROP_DOWN_COLUMN = from 2 to 3?

[e-harshpreetsingh]

This is awesome. One query- Do multi select options reflect in Pivot tables and get counted?

[melanieross]

I'm having a problem - the code script didn't work for me. Do I keep all the information in the new code? What you have on the video is different. Thanks!

[LILLACreations]

What about multiples columns? I've followed your instructions, and it worked perfectly, but when I tried to do different column, the column that was already done it gets undone.

[darshanshetty]

Worked like a charm. Thank you 🙂
Wondering if some formatting can be done. The cell is somehow right aligned. Also if any color can be included for the cell

[Hayot-ir]

Hi Joseph Code is not running if u choose in drop down setting "show a warning" is it possible to make it to choose without warning

[prague]

Suggestion: I believe you need to change the cell Range to include $ (e.g. A$2:A). Otherwise, when you copy the cell down, it won't allow you to select all of the options

[Dr.PriyankaBorhade]

Hi Joseph, thank you for the script. Please let us know how to do it for multiple columns. Thank you.

[luisangelacunag]

Hello! Thank you very much for the content, I would like to know how I can maintain the same configuration when creating a new sheet in the same document, in that new sheet I can have the same drop-down menus. Thanks for the support!

[allythebeee]

Thank you so much for the tutorial. It worked well and was very helpful ☺☺

[georgestoll]

The code link comes up as unsecure and can not access, as of April 30, 2024

[sofouda]

not working for me, despite trying it several time. Link is very different from what is shown in the video. not for neophytes like me 😔

[Itsjaguarjones]

Seems like the link to the code has been removed from your website. Shame

[curtistam]

Awesome code. Is there a way that you can modify it so that if you do manual edits to the cell that it won't override and keep the old text from coming back. Like if I have 1, 2, 3 and I want to erase everything and add 4. It keeps outputting 1, 2, 3, 4. Thank you!

[blaxmolasses]

how do you do this when the range is on a different sheet?

[bellayan]

there is an error, it says TypeError: Cannot read properties of undefined (reading 'value') what can i do

[douangmanyphoneyiem]

I cant view the app scripts from the above link you shared. Can you please share it with me here?