Weird behaviour with numbering.

Graham Rimell

I've noticed that Smartsheet seems to sort numbered files in an erratic way. I've realised now that it looks at the first number, and not the second (or 3rd) number.

So for a random set of numbers it'd go:

1

11

16

2

23

5

Rather than:

1

2

5

11

16

23

See an example here:

Is there a way to get it to order numbers properly?

Thanks.

Mark Cronk

Hi @GrahamR,

I use text with leading 0s to get sorts right. 1 is 01 or 001. 10 is 10 or 010.

I'm sure you can generate the right length string using a formula. That column could be used to sort but hidden if you don't want others to see it.

Curious if someone has a better answer.

Mark

Graham Rimell

That seems to be a decent work around for the time being. Tested it and it numbers correctly!

Thanks.

Leibel S

@GrahamR

the basic concept here is that being that this is Text not a Number it gets sorted exactly as you would expect text to be sorted.

For example in the alphabet "AA" comes right after "A" not after "B".