Is there a way to crate a custom sort order on reports?

Marina Iida
Marina Iida ✭✭
edited 03/10/22 in Smartsheet Basics

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?

  1. Critical
  2. High
  3. Medium
  4. Low

The only way I've been able to solve for this is to number these, so it always sorts from 1 to 4.