Not Started shouldn’t be between Complete and In Progress should it?
Is this intentional or unintentional? enums are sorted by the order of the values in the enum?
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.
User | Count |
---|---|
40 | |
29 | |
24 | |
24 | |
13 |