Are “Deep” Dynamic Dropdowns Possible?
Here is our scenario:
Our table (sheet) is setup with 4 columns labeled #1,#2,#3,#4. Our app has a form with 4 fields/questions. Each field is a drop down that is filtered based on the previous selection. After we select an option for question #1, the next field for #2 is filtered correctly using this Valid_If format (table[column]), After a selection is made for question #2, the options for question #3 are also filtered correctly.
The issue is question #4. We want that to be filtered based on the selection of question #2 and not #3. Right now using the format of Table[Column] works but forces #4 to look at #3…
Is there a way to have dynamic dropdowns look at a specific input?
Any helps appreciated.