Number column with leading zeroes

Jayy S.

I need a way to keep leading zeroes for numbers in a column, but also keep them in number format for sorting purposes. These are test codes so leading zeroes are necessary but Smartsheet kept converting them into text.

Paul.Woodward

Hello Jayy
There is not a lot of information to go off of but you should see the "ZERO" options in your tool bar (see below), to increase or decrease the amount of Zero's displayed in a cell. You can then add it to the entire column/row, so any # you add in has the amount of leading Zeros needed.

You could also add a new column that is "# Auto Number" Where you can set the display format for prefix, numerical places, and starting #'s. See below.

Please let me know if there is anything else I can do to assist!

Jayy S.

Unfortunately, no. The "zero" options are for decimals, not leading zeros. It's also not an auto-number column as these codes are assigned and we need to track them in SS.