The new Beta Interface only allows Pick items to be sorted. Records should be able to be sorted too, or at least show up in the same sorted sequence as the underlying table.
Here's an elegant solution to ranking. It assumes that you have a Table, e.g., "Users," with a field with some value, e.g., "CLV," and an empty numbers field, e.g., "Rank."1) Create an automation trigger to run the script, e.g., When a record is crea...
If you want to, for example, count the number of dates (or any data by the number of entries) in a lookup field, this works:COUNTALL(ARRAYUNIQUE({your_date_field}))
