Allow Successors() to show only immediate successors

AaronO

I like having a "successors" column to complement the "predecessors" column - I use this to trace forward to find tasks that are affected if I make a change. However, the successors() function returns not only immediate successors, but every task that is a child of those successors. While this may be technically a true result, it is a different result than I want - just as "predecessors" contains direct predecessors, I only want to know the direct successors.

Suggestion, then, is to add a parameter to successors() to instruct it to return only direct successors.

EagleScoutPatriot

@AaronO I'm curious what you mean that the Successors() returns all successors even through children tasks. Can you share an example formula for this? I'm actually wanting a solution that would be satisfied with your suggestion. I want to produce a list of all successors so I can simulate the Driving Path but in a filter. More ideal would be a formula for all predecessors through all parents.

Anyway, can you show how the Successors() formula can show both direct (immediate) and indirect successors?

Thanks!

doug.reynolds

I have the same question.
I have a Successors Column with the Column Formula:

=JOIN(SUCCESSORS([Task Name]@row), ",")

if a parent task (with 5 child tasks) points to a predecessor task, the predecessor task with show 6 successors, but I only want it to reference the one Parent Task