Is there a formula that I could use to place zeroes in the suffix?

This discussion was created from comments split from: WBS with additional naming.

Answers

  • Hi,
    A quick follow-up question. Is there a formula that I could use to place zeroes in the suffix?

    DepartmentA 001

    DepartmentA 001.1

    DepartmentB 001

    DepartmentB 001.1

    DepartmentA 002

    DepartmentA 002.1

    DepartmentA 002.2

    DepartmentA 002.3

    DepartmentB 002

    DepartmentB 002.1
    …..
    …..
    DepartmentA 011
    DepartmentA 011.1

  • Brian_Richardson
    Brian_Richardson Overachievers Alumni

    If you setup another column to add the 0s, you can avoid having a messy long formula for this.

    Here's the column formula to use in the helper column, I titled it "Suffix with 0s" or something similar. Then change your WBS formula to reference the "Suffix with 0s" column instead of the Suffix column

    =IF(Suffix@row < 10, "00" + Suffix@row, IF(Suffix@row < 100, "0" + Suffix@row, Suffix@row))

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!