Sort list of a dependent dropdown in Appsheet

AppSheet AppSheet Q&A
, ,
1

Here is my ‘Valid if’ formula to limit my list of names in the dropdown (dependent on two variables)

but the list are not alphabetically arranged,

Select(Stock Inventory[Item Name],AND([_THISROW].[Site]=[Site],[_THISROW].[Category]=[Category]))

How Can I Sort them alphabetically

Tried ORDERBY(Stock Inventory[Item Name], [Item Name)

Help!

2

SORT()

ORDERBY() is only for key values.

1 Like
3

sort(Select(Stock Inventory[Item Name],AND([_THISROW].[Site]=[Site],[_THISROW].[Category]=[Category])),false)

4

Thank you!!!