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), ", ")

whacker

This is another fundamental planning feature that SmartSheet has spent over a decade ignoring requests from users on. Until this basic feature is added, SmartSheet will never be an efficient planning platform.

Susan van Niekerk

Hi ArvindGP

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

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

Both versions return a UNPARSEABLE ERROR

Yet in another sheet I have the below working well ( Columns same if both sheets)

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

Susan van Niekerk

Jason Tarpinian

I don't know how new of a function it is, but SUCCESSORS() is a usable function: