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

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

• Options

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

• Overachievers
Options

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!