Basically I have two fields with drop-downs. I want to make it so when I fill one, the other only shows values that corresponds the one that I've filled before.
To this second drop-down I'll have a table with two columns: one with unique values and one with values that matches the ones on the first drop-down.
Solved! Go to Solution.
Hello please check this article https://support.google.com/appsheet/answer/10106620?hl=en&ref_topic=10102053#:~:text=Dependent%20dro....
also, check the TEMPLATE APP
Hello please check this article https://support.google.com/appsheet/answer/10106620?hl=en&ref_topic=10102053#:~:text=Dependent%20dro....
also, check the TEMPLATE APP
Thank you, it worked.
There's only one problem: the values on the second field are not sorted.
If I use a sort function inside the valid_if, the field loses its relation with the other field. If I just put the name of the table and column in the valid_if, it works as intended but then the values are shown in a very random order.
Any way to fix this?
check out function ORDERBY()
I've managed to get the sort working by making the drop-down myself instead of just naming the column, like this:
SORT(SELECT(FรBRICAS_PUPS[PUP], [FรBRICA]=[_THISROW].[FAB]))
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |