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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 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!