Okay, first attempt at explaining what I want to do....
I have a sheet where I track items (rows) with a multitude of attributes (columns). It's fairly unwieldy so I wanted to provide Editors with a form to submit new items.
Current Form:
User enters Title and Description (text columns 1 and 2), selects the Category from a single-select drop-down (list column 1), and selects a Descriptive Type from a single-select drop-down (list column 2)
Not all of the types apply to every category so I wanted to apply conditional logic to the form:
Based on the Category Selection, I would like to present a partial list of Descriptive Types. If the user selects Category A, then I want to present a drop-down Descriptive Types 1, 2, and 3. If the user selects Category B, I want to present a drop-down with Descriptive Types 4, 5, and 6. (And so on)
Is that possible to do?
Alternatively could I display a unique column based on a selection in a previous column? (If a user selects Category A, then they see a drop-down for Category A descriptive types (unique column); if a user selects Category B, then they see a drop-down for Category B descriptive types (different unique column).....
Thanks in advance for any guidance, suggestions, or redirection.