AnsweredAssumed Answered

Sort Records, Sort Order, Custom Order based on Value List-Not giving desired results

Question asked by lindseym on Jul 3, 2017
Latest reply on Jul 7, 2017 by lindseym

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

Screen Shot 2017-07-03 at 9.46.48 AM.png


What I get:


The "Level" column appears in the order: 1-21,B,R


Screen Shot 2017-07-03 at 9.47.03 AM.png



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.





Screen Shot 2017-07-03 at 9.54.01 AM.png


I'm stumped.