UX View Options Sort By not in alphabetical order

View Sort Order not displaying in Ascending or Descending.

In the data I have 4 entries for Status. REPORT, PENDING, CLOSED, CLOSED BY MC. When I try to sort or Group by Status I get them out of order.

Example: Sort By Status–Descending
PENDING
CLOSED
CLOSED BY MC
REPORT

Example: Sort By Status–Ascending
REPORT
CLOSED BY MC
CLOSED
PENDING

Same with GROUP By–

Why is it not in alphabetical order?

If the Status column is of type Enum, the sorting order is determined by the order the Enum values are defIned in the column definition. You can slide them around into a new order using the widget highlighted here:
image

After:
image

Thanks, Steve. Only two appear as ENUM as the data is then processed on another app to add actions that change the status. I have a temp fix with a SWITCH virtual column and then sort by that column but then you lose the STATUS word so I added a color.

switch([STATUS],
“REPORT”,1,
“PENDING”,2,
“CLOSED”,3,
“CLOSED BY MC”,4,
5)

This virtual column does not work.
switch([STATUS],
“REPORT”,“1 REPORT”,
“PENDING”,“2 PENDING”,
“CLOSED”,“3 CLOSED”,
“CLOSED BY MC”,“4 CLOSED BY MC”,
5)

What does “then you lose the STATUS word” mean? In a view, a sorting column doesn’t need to be displayed.