WBS Numbering

CJU

Hi

I searched the help but could only find a 2018 listing.

What I would like to have is an auto-numbering that is parent dependent so that we have e.g.

1 - Parent

1.1, 1.2, 1.3 - children

If there was another parent under the master, that would become 1.1.1; 1.1.2 etc

Is this possible or does it need to be a manual entry?

Craig

L_123

I know a way to do this if you don't every move the rows around on your sheet, but if you sort the sheet or manually move rows it will mess it up. Maybe someone else can offer a less breakable option, but if that seems reasonable to you I can type it out.

CJU

My preference would be auto-number so that lines stay in order if a filter is applied.

L_123

Filtering wouldn't change anything, just the rows actually changing position. When you filter it doesn't change anything other than the appearance. Sorting and manually changing the rows positions would

CJU

Great, what is your solution?

L_123

Create an autonumber column to the right, and count the amount of values in said column that appear between the current row and the parent row and add one to get the number of rows deep.

CJU

Appologies, not sure I understand

L_123

https://publish.smartsheet.com/101c654548294d449588fb69c4462d6b

CJU

I placed the fomulae but its not working

L_123

Can you show the formula you typed?

*delete the 1 in the top row return column

CJU

=IF(COUNT(ANCESTORS()) > 0, VALUE(PARENT() + "." + COUNTIF(Autonumber:Autonumber, AND(@cell < Autonumber@row, @cell > PARENT(Autonumber@row)))) + 0

L_123

I made this for one level of hierarchy. Delete the 1 in the project test case row and I think it should work.

CJU

which column?

CJU

When I delete the "1" from the Project Test Case row, all the "Return" numbers below it are deleted

L_123

ohh.... there are 3 level of hierarchy on your sheet. I didn't notice that. Give me a minute

CJU

I have

Master - top line 1

below it should be 1.01 etc.

Initiation - 1.1

below it should be 1.11 etc.