Sort Syntax

AppSheet AppSheet Q&A
1

Hello - is there a way to have a dropdown list sorted other than by the chosen column? For example:

SORT( LookupTable[ColumnC]) - I have a product table that I reference in an Order Details table (linked to an Orders table). The syntax I use in a Valid_If statement in the Ref field is SORT(Products[ProductName]). This displays the list of products in my dropdown. However I need to display them in a different order than the alphabetic listing based on the product name. I have a column called DisplayOrder where I can modify the list in order of how often they are used by drivers in the field so selecting them is quicker.

So my question is can I get the list to display the productName but in order of the DisplayOrder? Perhaps SORT is not the correct expression to use.

Thank you
Ray

2

Thanks Steve - do I place the expression in the Products Ref column or is it used in the table to display the data returned for other uses in addition to the drop down select list?

Cheers

3

You’d use it the Valid If expression of the column in which the user from choose from the list.

4

Awesome - much appreciated. Thank you

Be safe

Ray

1 Like