Not Started shouldn’t be between Complete and In Progress should it?
That’s a feature of Enum values: the order the values are listed in the column definition are their sorting order.
Thought I was going crazy with how they sorted themselves. Seems useful in some situations. If I just make a virtual column that equals my enum as a text column it would sort normally correct?
You could, or you could use a normal Text column (instead of Enum of Text) with a Valid If expression that produces the list of values you want allowed.