LinkedIn
Twitter
1 ACCEPTED SOLUTION
Well, that is an entirely different question! 
The order of items in a dropdown list can be sorted however you chose. If you have a list of Ref values, wrap the list with an ORDERBY() expression. For instance, to sort a list from the Related Order Details column by their row numbers in the spreadsheet:
ORDERBY([Related Order Details], [_ROWNUMBER])`
The expression is commonly used as the Valid If expression, to limit the userโs choices to only those entries in the list.
See also:
