Numeric Column Type

Michael Smith · 10/03/16

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.31

...

Would a purely numeric column type take care of this sort issue?

Brett Evans · 10/03/16

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

Michael Smith · 10/03/16

Ok. Great! Thanks Brett.

JamesR · 10/04/16

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.

Welcome to the Smartsheet Forum Archives

Numeric Column Type

Comments

Categories