Auto Number according to levels

Eugene Botha

HI all, is there a formula that can auto number in sequence to levels. So I dont have to type in my Row Id's manually. To start with "0" as the main task and every sub task from "1" and onwards. Then again under "1" to go to "1.1"

kowal

hi @Eugene Botha,

Yeah it's possible to do it automatically but my solution needs 6 helping columns to calculate those.

So to create WBS based on the Primary column you would need to use those 6 calculations columns (light green).

Brian Wilson DC

@Eugene Botha Hello, Eugene! I believe up until recently this was the workaround to have Smartsheet produce an automated WBS column. This may have changed in the past 2 years, but I've been searching for a while this morning and can't find anything to the contrary. At least this might give you a place to start!

https://community.smartsheet.com/discussion/88512/automatic-numbering-for-work-breakdown-structure

Regards,

Brian

kowal

hi @Eugene Botha,

Yeah it's possible to do it automatically but my solution needs 6 helping columns to calculate those.

So to create WBS based on the Primary column you would need to use those 6 calculations columns (light green).

Paul Newcome

Here's a link to the thread with column formulas laid out:

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