WBS Formula help

Melissa Torrez

I am trying to join the WBS formula to include another level or substep

ID formula = IF([ID_Parent]@row <> "", [ID_Parent]@row, JOIN([ID_Child]:[ID_Child], ".", [Child_Count]@row))

I want the result to be WS1.1.2.1 instead of just displaying .1 under WS1.1.2

Julie Fortney

Hi @Melissa Torrez,

Try this formula: =IF([ID_Parent]@row <> "", [ID_Parent]@row, PARENT([ID_Child]@row) + "." + [Child Count]@row)

This will fix your issue on the row you specified. I don't know what your formula is in the ID Child column, but if you can add an IF statement to pull in the ID_Parent in if ID_Parent is not blank, I think the ID column formula noted above will work.

I hope this helps!

www.linkedin.com/in/julie-fortney-pmp-lssblackbelt