This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is there a way to sort alphanumeric fields so they sort like this:
```1
2
100```
Rather than this:
```1
100
2```

I have the same issue but with sizes. 
```S
M
L
Xl
2Xl
3Xl
```
ather than:
```2xl
3xl
l
M
S```

You should be able to create a Formula (Text) field with a formula like this:

CASE
    WHEN {field} = 'S'   THEN 'A'
    WHEN {field} = 'M'   THEN 'B'
    WHEN {field} = 'L'   THEN 'C'
    WHEN {field} = 'Xl'  THEN 'D'
    WHEN {field} = '2Xl' THEN 'E'
    WHEN {field} = '3Xl' THEN 'F'
    ELSE {field}
END

And then sort on that field, smart I like your Idear I’ll give it a try. <@U9CS7LVCN> 