Sorting consecutive numbers with text

Options

Hi,

This might have a very obvious answer, I have a list of items with unique numbers, I want to sort them but some of the cells will have additional text, e.g. "34563 item 1".

I want it to look like this:

34563

34563 Item 1

34563 Item 2

34564

34565

But when I sort the column it doesn't put these 'text' cells underneath their numbered counterpart. I end up with something like this:

34563

34564

34565

34563 Item 1

34563 Item 2

etc.

It there a way to sort them consecutively or do I need to move the text to a new column, if so is there a way to avoid doing this manually?


Many thanks,

Tim.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!