Work Breakdown Structure (WBS)

Stephen Stofanak

Are there any plans to add the ability to display a graphical (hierarchical boxes) WBS?

 

Stephen

Frank Falco

Using three columns, RowID, Level & WBS. I hide RowID and Level.

Task is the column with the Task Names in it.

$1 assumes you are starting on row 1, but change that if you are starting on another row.

RowID: =COUNT($Level$1:$Level@row)

Level: =IF(Tasks@row <> "", COUNT(ANCESTORS()) + 1)

WBS: =IF(Level@row = 0, "", (IF(Level@row = 1, COUNTIF(Level$1:Level@row, 1), "" + PARENT() + "." + COUNTIFS(Level$1:Level@row, Level@row, RowID$1:RowID@row, >(PARENT(RowID@row))))))

Hope that helps until the feature is added into SmartSheet