Auto Number according to levels
HI all, is there a formula that can auto number in sequence to levels. So I dont have to type in my Row Id's manually. To start with "0" as the main task and every sub task from "1" and onwards. Then again under "1" to go to "1.1"
Best Answer
-
hi @Eugene Botha,
Yeah it's possible to do it automatically but my solution needs 6 helping columns to calculate those.
So to create WBS based on the Primary column you would need to use those 6 calculations columns (light green).
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn!
Answers
-
@Eugene Botha Hello, Eugene! I believe up until recently this was the workaround to have Smartsheet produce an automated WBS column. This may have changed in the past 2 years, but I've been searching for a while this morning and can't find anything to the contrary. At least this might give you a place to start!
https://community.smartsheet.com/discussion/88512/automatic-numbering-for-work-breakdown-structure
Regards,
Brian
-
hi @Eugene Botha,
Yeah it's possible to do it automatically but my solution needs 6 helping columns to calculate those.
So to create WBS based on the Primary column you would need to use those 6 calculations columns (light green).
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn!
-
Here's a link to the thread with column formulas laid out:
https://community.smartsheet.com/discussion/77827/work-breakdown-structure-wbs-column-formula-configuration/p1
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.4K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 492 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!