Is there a formula that I could use to place zeroes in the suffix?
System
Employee
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 001DepartmentA 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 -
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))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!