Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Proceeding Zeros to an already existing column.

    ✭✭✭
    in Formulas and Functions

    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?

    · Share on FacebookShare on Twitter

    Best Answer

    • ✭✭✭✭✭
      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

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭
      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

      · Share on FacebookShare on Twitter
    • ✭✭✭
      sharkasits

      Thanks again for your help! That worked.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions