Create multiple dropdowns where you can select more than 1 from dropdown, options available in dropdown is dependent on previous selection.

[stacyloufurious]

I'm working with data where I have 2 areas, each with multiple regions, then each region with multiple markets. I'd like to have the user select from the 1st dropdown of 'areas', then the regions available to choose from in the next dropdown will be dependent on the area(s) selected, and the markets are then dependent on the region(s) selected. This is the base.

With that, I want the user to be able to select 1 or more from each dropdown when needed and if they select any value in error they should be able to remove that one value without erasing everything they may have already selected for that field.

Any direction, help on this is greatly appreciated!!!

 

[PilsburyKush]

This can be done with an IF statement within your data validation parameters of your drop down list. But, you cannot multi-select in a drop down menu. Let me know if you need additional help.