I've found multiple sources listing a myriad of ways to create a dependent dropdown list that either uses data validation and other options.
Is it possible to vary the total number of dropdown lists based on what is needed?
Say I have 3 items in a main list. The first and second have 3 levels of selections that could be selected from a dropdown list, but the third has a fourth.
How can I tailor the sheet to show the correct number of lists? I.e. the first two would only show 3 dropdowns, the third would show 4?
Or is it possible?
*also, this is very new in the creating phase, although I can make a dummy sheet showing what I'm saying if it isn't clear...