Successors formula returns error "#invalid column value"

PBC

Formula =SUCCESSORS([Task]@row)

Returns "#INVALID COLUMN VALUE"

=[Task]@row returns the text in the Task column.

The column format with the formula is text number

Dependencies are enabled

It must be simple and i'm just not seeing it.

AmandaWebb

It appears that Successors must be used in conjunction with other functions, not just as a standalone function.

I pulled this from the help page, hopefully this will help

Example 1

=JOIN(SUCCESSORS(column@row),CHAR(10))

Combined with the JOIN function in a multi-select dropdown column, this formula calculates a task's direct successors. It returns a collection of task row numbers that occur due to the referenced task.

Example 2

=COUNT(SUCCESSORS(column@row))

Determines the number of direct tasks reliant on the current task.

Example 3

• =COUNTIFS(Successors:Successors, HAS(@cell, [Row #]@row))
• =COUNTIFS(Successors:Successors, HAS(@cell,
• [Row #]@row), [% Complete]:[% Complete], 1)

If all predecessor tasks are 100% complete, check a box indicating that the current task can be started. This solution requires a Row Number helper column and another with the above JOIN/SUCCESSORS formula.