Creating a drop-down filed dependent of another one

[Excelsoxls]

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.

[VOLODYMYR_TYROL · Accepted 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

https://www.appsheet.com/templates/How-to-create-a-dropdown-menu-with-values-that-depend-on-earlier-...

[Excelsoxls]

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?

[VOLODYMYR_TYROL]

check out function ORDERBY()

https://support.google.com/appsheet/answer/10107362?hl=en

[Excelsoxls]

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]))