Work Breakdown Structure (WBS)

Frank Falco · 07/02/19

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

Andrée Starå · 07/03/19

Hi Frank,

Nice work!

Thanks for sharing!

Best,

Andrée

Comments