Auto-numbering for Sub-items / Hierarchical Relationships
Good morning,
I would like to know if there are any plans for updating the Auto-numbering system to take account of hierarchical relationships, such as:
1.
1.1
1.1.1 ... and so on.
I have seen a few posts on this forum from years back which have requested this feature, with confirmation from Smartsheet employees that this was in the works (https://community.smartsheet.com/discussion/8536/auto-numbering), so it I find it surprising that this still hasn't been done.
Further to this, is there a work-around I can implement in the interim in order to implement a numbering system that takes this into account? Any solution would be most welcome!
Kind regards,
Gerhard
Best Answer
-
This is an interesting thread. I followed the links that Andree put up and experiemented with that sheet. These are my results:
In my humble opinion, this solution doesn't work, the numbers are NOT what I would expect from a WBS. EDIT!!! After posting this I went back to the sheet where I took the above screen grab and it had saved and amended all the WBS code to a code that WAS Correct!! Weird that it saved like this first though!
The same parent list in my sheet comes out with these results:
APOLOGIES - I noticed my screen shot above has incorrect Level4 within the numeric only code, that is due to me only coding up to level 3 in that column! I only developed this as an exercise for myself! I went up to Level 4 in the Alpha and level 3 in the numeric. Have adapted the IF to state no level 4!
Happy to share you to the sheet if you'd like to see how this was achieved.
Kind regards
Debbie
Answers
-
I hope you're well and safe!
Have a look here.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I too have an example of a WBS Structure that works to level 4 including Alpha characters if you are interested.
Happy to share an example sheet with you. My email address is debbie.sawyer@Smarterbusinessprocesses.com
Kind regards
Debbie
-
This is an interesting thread. I followed the links that Andree put up and experiemented with that sheet. These are my results:
In my humble opinion, this solution doesn't work, the numbers are NOT what I would expect from a WBS. EDIT!!! After posting this I went back to the sheet where I took the above screen grab and it had saved and amended all the WBS code to a code that WAS Correct!! Weird that it saved like this first though!
The same parent list in my sheet comes out with these results:
APOLOGIES - I noticed my screen shot above has incorrect Level4 within the numeric only code, that is due to me only coding up to level 3 in that column! I only developed this as an exercise for myself! I went up to Level 4 in the Alpha and level 3 in the numeric. Have adapted the IF to state no level 4!
Happy to share you to the sheet if you'd like to see how this was achieved.
Kind regards
Debbie
-
@Andrée Starå and @Debbie Sawyer,
Thank you so much to the both of you for taking the time to get back to me, and for your suggestions!
@Debbie Sawyer, thank you also for the screenshots above, I agree that the solution in the thread shared by Andrée does not match what I would expect from a WBS. I will take you up on your kind offer for a sample of the sheet you're currently using, as it looks to be exactly what I was hoping for.
Many thanks once again and best wishes to you both!
Kind regards,
Gerhard
-
If you email me your Smartsheet login ID I will share the sheet to you and you can take a copy of it.
My email is debbie.sawyer@smarterbusinessprocesses.com
Kind regards
Debbie
PS - I made an edit to my reply. The template that Andree shared did work eventually, it just went through a strange set of numbers before saving the correct code... Just wanted to point that out! :D
-
Hello,
as helpful as the workarounds shown here are, I'm really wondering if this isn't a function that Smartsheet can integrate? It's been talked about for a couple of years already! We are using one of the workarounds on a 1000-line long sheet and it's making it extremely slow in updating the formulas...
-
@Debbie Sawyer I found this thread in Smartsheet community and was wondering if you still had the sample sheet available to share? I am trying to create something similar and would like to incorporate letters as you have shown here. Thank you.
-
HI Melissa, yes, email me on debbie.sawyer@smarterbusinessprocesses.com with the email address that you want me to share the sheet to and you can have a copy of it 😊
Kind regards
Debbie
-
@Debbie Sawyer Hey there! Like Melissa, I found this thread and was hoping you could please share your sheet with me (shaayann_khalid@teamhealth.com). Thank you!!
-
Thank you for the email. I have shared the sheet with you. Good luck with it! 😉
Kind regards
Debbie
-
Hi @Debbie Sawyer Can you please share your genius with me as well?
-
Of course, but you'll need to send me your email address, so that I share the sheet to it :D
Mine is in my profile data.
Kind regards
Debbie
-
Hi Everyone,
can someone help me understand the purpose of WBS?
What is the benefit of implementing it? I creates programmes with rows and hierarchies so wondering how I can make use WBS..
-
Hi Maz
WBS is just a name for listing your tasks out in a sheet. It is the Work Breakdown Structure. i.e. you are structuring your work to allow you to track its progress. This thread is detailing how the rows are numbered automatically to allow you to reference tasks within the sheet.
You are most probably already implementing a WBS in your Project Sheet without realising it! If you have something like a phase heading followed by all the tasks that you need to complete with that phase of work, then you indeed have a work breakdown structure in your sheet.
The numbering is simply for reference purposes.
I hope this helps.
Kind regards
Debbie
-
@Debbie Sawyer Can you also share this with me? sgrossman@enterprisecommunity.com
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
