How to fix numerical sorting

vmase
vmase
edited 04/03/24 in Smartsheet Basics

hello looking for suggestions on how to fix the sorting. After. 9 it sort to 1

how can can I make this to be sequential?

Answers

  • KPH
    KPH ✭✭✭✭✭✭

    You can change the string to be a consistent length, for example

    Instead of

    7.2.1,     7.2.2   ...   7.2.10
    

    Use

    7.2.01,    7.2.02   ...    7.2.10
    

    etc.

    You might need to make each part 2 digits if you ever get to 7.10.01