Successor Column

Susan van Niekerk

Hi Brain Trust

We have a sheet using predecessors and have just been ask if we could have a Sucesor column -

iIt would be good to know when amending a date what other items are dependent on that date 

AravindGP

Hi @Susan van Niekerk

You have add a Successor column and have a formula in there if you already have a Row ID column. Your formula would be

=JOIN(COLLECT([Row ID]:[Row ID], Predecessors:Predecessors, [Row ID]@row), ", ")

This will populate the rows which are directly marked as a Predecessor for each row.

Here's how the results would look like

You can change the collect to populate the name of the task instead by changing Row ID to Task Name in the above formula.

Susan van Niekerk

Formula

=JOIN(COLLECT([Task Name]:[Task Name], Predecessors:Predecessors, [Task Name]@row), ", ")

But it isnt returning Anything

=JOIN(COLLECT(Row:Row, Predecessors:Predecessors, Row@row), ", ") is working and will return ROW ID

AravindGP

Hi @Susan van Niekerk

Try this formula

=JOIN(COLLECT([Task Name]:[Task Name], Predecessors:Predecessors, [Row]@row), ", ")