Autonumbering including sub-items (indented/outdented)
Hi,
I am fairly new to Smartsheet, and would like to autonumber as shown in the image;
I have found this possible solution (https://community.smartsheet.com/discussion/4050/auto-numbering-sub-items), but I is this the ONLY option? It seems like a basic task to me.
Answers
-
There is currently no way to have this automatically done without setting up some helper columns. Most other solutions that I have seen are very similar to this one. If you do a search in the Community for "WBS", you should find a few other variations, but they are all pretty much the same idea.
-
Hi @Truwayne Gordon, @Tom Zylstra, on the Smartsheet team, recently posted about a WBS configuration. If you check out his Community Post there is a link that can give you direct access to a sheet that has the WBS structure built in that you can start using: https://community.smartsheet.com/discussion/77827/work-breakdown-structure-wbs-column-formula-configuration
Cheers,
Lea
-
@Lea Gikas In the template for the WBS, the Health column/color is calculated and turns yellow at 4 days. How do I change this to be 14 or 21 days?
-
@Michael Braatz Are you able to paste the formula into here from the sheet?
-
=IFERROR((IF(OR(Start@row = "", Start@row > TODAY()), "Blue", IF(OR([% Complete]@row = 1, Finish@row > TODAY(+[Task Duration Health Workdays]#)), "Green", IF(Finish@row < TODAY(), "Red", IF(NETWORKDAYS(TODAY(), Finish@row) < [Task Duration Health Workdays]#, "Yellow", "Green"))))), "")
-
@Michael Braatz It looks like maybe a number is being stored in a sheet summary field.
[Task Duration Health Workdays]#
If that number is 4, try changing it to 14 to see if that gets it working for you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K 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!