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

System

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

BrendonP12222

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

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))