Sort reference list

[Alfredo_Pou]

In the sales form I have a dropdown referenced to the customer table to select the customer for that sale.
I want to order this list, so that the customers who buy the most come first, to simplify the operation.
I thought about putting in Data Valid an expression that returns the list of customers ordered using SORT (), but I see that sort does not allow applying ordering criteria.
How could I sort my customer list in a Ref Dropdown?

[Alfredo_Pou]

ok i think i found it myself.
There should be a reference to related functions in the SORT () help that shows the existence of ORDERBY ()

[Steve]

And so there shall be! As requested:

help.appsheet.com

SORT()

Sorted list items