Hi!
I'm using an Enum column with ref values from another table and I would like the ability to sort the resulting list of references in alphabetical order for users to find the data they're looking for easily.
The reference table has a combined image and text label. I would like to preserve the label in the Enum column for QoL purposes.
I'm open to Appscript solutions/workarounds as well!
Have you tried using the Suggested Values property for this?
ORDERBY(SELECT(RefTableName[KeyColumn], TRUE), [ColumnNameToSort], FALSE)
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |