WBS Formula help

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


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!