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.

 

Cheers,

-L

Outcomes