Sequential Numbering Autopopulate Row
Hi all! I am trying to create a formula where every time I add a row, it aligns with the next number in the series. If it reaches a level 1 row however, the series goes to the next whole number. I wrote out manually what the numbers should be but I would like a formula to apply this automatically when i add a new row. Im not sure if this should be a formula or an automation - but it looks like you can't put formulas in the automation text box.
Answers
-
Hi,
Are you trying to create a WBS structure? If so, you would need to have your Level column use the Ancestors formula. For example: =COUNT(ANCESTORS([Task ID]@row)) + 1
Does that work?
Darla Brown
What you meditate on, you empower!
Overachiever - Core Product Certified - Mobilizer - EAP
-
There is also a template in the template gallery that has all the formulas built in for the WBS structure.
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!