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?


  • 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? Jan 31, 2021 at 6:09
  • Something similar to this type of function - spreadsheetpoint.com/multiple-selection-drop-down-google-sheets 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? 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. 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. Jan 31, 2021 at 6:32


Your Answer

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

Browse other questions tagged or ask your own question.