In a script, I have a sort order.
I have broken out the sort order as it's own script while I test it out.
What I want:
The "Level" column to appear in the order: B,1-21,ROOF
What I get:
The "Level" column appears in the order: 1-21,B,R
The level is set up as a calculated field with the outcome being a number. I have tried it as text with the same issue, and if I am using a custom value sort order I'm not sure why it would matter if it was text or number.