@David_V You don’t have to be shy, hook me up with the actual column and table names so I can just pound out the expression…
ORDERBY() will organize a list of KEYs…
Sorting a List of Keys with ORDERBY
You can sort a list of Keys using the ORDERBY function.
This can be used to sort the values in a Ref dropdown (by modifying the App Formula of a Related References virtual column) or to control the order of rows displayed in a workflow rule Start expression.
ORDERBY(, , , , , …) to sort a list of keys. The first argument must yield a list of references, i.e. a list of the keys of the records to sort. This is followed by one or more pairs indicating a column name to order by, and its ordering direction. The value TRUE indicates “Descending” order. The value FALSE indicates ascending order. If the data should be ordered by just one column (which is the common case), the ordering direction may be omitted and defaults to FALSE (so the rows are sorted in ascending order). For example, OrderBy([Related Orders], [Customer Name], [Order Date], FALSE).
SOOOOO the best thing to jamb in for is a FILTER.
FILTER is a special case of SELECT which is used to construct a list of row references by applying a filter condition to a table.
FILTER(Customers, [State] = “WA”)
— returns a list of customers in WA state FILTER(Customers, [Country] = “USA”)
— returns a list of customers in the USA