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 ... 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

Find more posts tagged with

Accepted answers

Debbie Sawyer

@Gerhard da Costa Pinto

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

All comments

Andrée Starå

Hi @Gerhard da Costa Pinto

I hope you're well and safe!

Have a look here.

https://community.smartsheet.com/discussion/77827/work-breakdown-structure-wbs-column-formula-configuration

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!

Debbie Sawyer

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

Debbie Sawyer

@Gerhard da Costa Pinto

This is an interesting thread. I followed the links that Andree put up and experiemented with that sheet. These are my results:

The same parent list in my sheet comes out with these results:

Happy to share you to the sheet if you'd like to see how this was achieved.

Kind regards

Debbie

Gerhard da Costa Pinto

https://community.smartsheet.com/discussion/comment/285588#Comment_285588

@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

Debbie Sawyer

@Gerhard da Costa Pinto

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

Oliver David Krieg

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...

Melissa Torrez

https://community.smartsheet.com/discussion/comment/285588#Comment_285588

@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.

Debbie Sawyer

@Melissa Torrez

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

smartshaay

@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!!

Debbie Sawyer

@smartshaay

Thank you for the email. I have shared the sheet with you. Good luck with it! 😉

Kind regards

Debbie

Sean D1

Hi @Debbie Sawyer Can you please share your genius with me as well?

Debbie Sawyer

@Sean D1

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

MazU

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..

Debbie Sawyer

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

SusanG

@Debbie Sawyer Can you also share this with me? sgrossman@enterprisecommunity.com

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.