Hi. I am trying to create an app that has 4 dependent dropdowns - but I also have other columns in that sheet for the user to input data. Should I put the dependant on a second sheet and than reference the second sheet? How do i get app sheet to recognize the second sheet as a reference, I have tried valid if but doesnt seem to pick up the reference?
Thanks
Shakeel
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |