How can I select multiple values from a dropdown list in Google Sheets?

Ask Question

Asked 3 years, 7 months ago

Modified 3 years, 7 months ago

Viewed 3k times

I have created a drop-down list, and I want to select multiple values every time I click on it. Is there a way to do without the script editor?

serenesat

9,98330 gold badges32 silver badges50 bronze badges

asked Jan 31, 2021 at 5:44

Vineyard Teacher

272 silver badges9 bronze badges

1

I am afraid you can not. You will have to create all possible combinations. I looked at your sheet. What values would you wish to select?
– marikamitsos
Commented Jan 31, 2021 at 6:09
Something similar to this type of function - spreadsheetpoint.com/multiple-selection-drop-down-google-sheets
– Vineyard Teacher
Commented Jan 31, 2021 at 6:17
Only with a script (which actually is a hack). But why would you want that? What are you trying to achieve?
– marikamitsos
Commented Jan 31, 2021 at 6:23
I am planning on using that as an indicator to alert teachers of potential problems with the student. The number of values selected will count as an offense. After enough of them are selected, it will send out an email to the administrator.
– Vineyard Teacher
Commented Jan 31, 2021 at 6:30
So you will have 1st offense, 2nd offense and so on. Then why should one pick multiple values? I am trying to understand the logic behind it.
– marikamitsos
Commented Jan 31, 2021 at 6:32

| Show 2 more comments

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.