Does " Automatic numbering for Work Breakdown Structure " exist in SMARTSHEET ? It's been a couple of days now that I am searching for .
Can someone help me ?
You should be able to copy cells. If you copy a cell from row 1, you can paste that formula into your sheet. This will allow you to change the column names to whatever is on your own sheet and make any other adjustments as needed.
I started using Smartsheet and evaluating its capabilities only a week ago, but from the very start faced that nasty limitation. After spending some time, I managed to come up with a solution that supports an unlimited level of nesting. Hope it will be helpful for those hitting this page 😁
Create the following columns and formulas:
You can have an automated reference column (select 'Auto Number / System' when adding a column) which allows you to set the format of the numbering however it is incremental. I.e. you can have 1.1, 1.2, 1.3 etc but it wont notice or be changeable to 2.1, 2.2, 2.3 etc for your next work package.
I've also done a search on the templates for WBS and Work Breakdown Structure, which provide no returns which leads me to suspect that currently, it is not something you can do through SS (unless you manually assigned the number system).
Hope that answers your query,
Thanks JACK ,
It is a great shortcoming to fix .
I have some examples published elsewhere here in the Community. I will search for them and get back to you once I find something.
How many different levels of hierarchy will you be using?
Hi PAUL ,
I am reading currently your last example . I am having big headaches lol .
I am using five levels of hierarchy to plan my project .
How can you help me ?
Can you include a link to the post/example so that I can see what you are starting with? That way I can better figure out how to help tweak things to fit your needs.
Nice PAUL ,
Please find the link of the example below :
I do not mind sharing my project sheet too . Tell me If you want .
What part exactly are you struggling with?
I can't copy rows from your sheet , since it is " view only " mode .
Thanks PAUL !
Check below the result when I follow your instructions .
Great workaround !
Congratulations and thank you very much 👌
Happy to help! 👍️
Will this allow accurate sorting on WBS or just help in automating the numbering. Can't create a report from your sheet.
To sort, you will want to ensure that the top row stays at the top. The absolute references to row 1 mean that row 1 needs to stay in place. Everything else can be sorted, and the formulas will remain intact.
I am not sure why you need to create a report from my sheet? It is a published view so that everyone can see how it works without having to give individual permissions.
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.