Proceeding Zeros to an already existing column.

Hi, I'd like to add Proceeding zeros to an already existing column

Currently there are over 2000 rows in the, with a varying number of digits from 1-4. I'd like them all to be a 4 digit number.

So if the column has an entered number of 1, I'd like the proceeding zeros to make it a 0001

or 501, but 0501.

Is this currently possible?

Best Answer

  • sharkasits
    sharkasits ✭✭✭✭✭
    Answer ✓

    I don't think you can update the column, but you can create a calculated field to do it. Would that work?

    I was just playing with this the other day and this is what I came up with.

    =LEFT("0000", 4 - LEN([column]@row)) + [column]@row


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!