Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Numeric Column Type
Has anyone noticed that the alpha/numeric column doesn't sort properly when numbers are in the following format: 1.5.1.1, 1.5.11.2...........11.5.11.40. You get this:
1.5.11.1
1.5.11.10
1.5.11.11
...
1.5.11.2
1.5.11.20
1.5.11.21
.......
1.5.11.3
1.5.11.3
1.5.11.31
...
Would a purely numeric column type take care of this sort issue?
Comments
-
You have to include leading zeros in each decimanl place if you want this to sort properly.
So this,
1.5.11.1
1.5.11.2
Would become
1.5.11.01
1.5.11.02
Thanks,
Brett
-
Ok. Great! Thanks Brett.
-
Michael,
The reason is that the moment you add the second Decimal it converts it to text and therefore sorts accordingly.
And yes the Numeric Column type I believe would be useful as well as Alpa numeric.