Multi-DropDown DataValidation

Updated on Oct. 22nd 2018!

​

I have finally updated this add-on due to getting tons of messages about it having stopped working in the summer. Some of the differences between the development and production environments for the code here caused some difficulties, however, I think it is working now!

Let me know in the comments below if you have problems!

It works by saving in the PropertiesService the sheet where you want the dropdown, and the location of the categories. For example, here is the function that creates the named range dropdown.

It is a fairly simple process but there are so many different custom use cases, it is really difficult to build a tool that fits all needs. If there are custom implementations that you need, contact me and with any luck we can work together on a similar project!

Jordan Rhea - I’m a front-end web developer. Follow me at @rheajt if you want to talk, discuss, or fix any of my code! I am passionate about using JavaScript in Google projects, but there are many more applications. I want to learn them all.