Expression with Switch and OrderBy

tvinci
New Member

Hello AppSheet

I would like to alphabetize the Suggested_Values constraint for a column using ORDERBY().

I do not know why I am receiving errors. Does anyone else know?

Thank you.

-Tiffany

switch([Route Quickset],

"Mandatory AM Broward",orderby(select(locations[name],and([Route?]="Broward",[Mandatory AM?]="TRUE")),locations[name]),

0 3 219
3 REPLIES 3
Top Labels in this Space