Is there a way to crate a custom sort order on reports?
I have a report that includes a "Priority" column (single select - Critical, High, Medium, or Low). When I use the sorting function in the sheet, I think it sorts in the order of the list that I typed in the column properties.
However, when you're in a report, the sorting only allows for ascending or descending (numerically/alphabetically).
Is there a way to create a custom sort, so it goes in the following order?
The only way I've been able to solve for this is to number these, so it always sorts from 1 to 4.