Used within another function to calculate the direct successors of a task and return succeeding task row number(s) that occur as a result of the referenced task.
Sample Usage
= JOIN(SUCCESSORS(Column@row),”,”)
Syntax
SUCCESSORS(
-
value
-
value—The value, typically a cell to evaluate.
Usage Notes
- Predecessors create date-based dependencies between tasks. A specific date-driven event for one task must have occurredbeforethe next task can begin.Successorsare the tasks with a dependency directlyafterthe date-driven event for a particular task has occurred. They’re the task(s) that can begin after a task is complete.
- You must enable dependencies to use this formula or you’ll see an #INVALID COLUMN VALUE error.
Examples
=JOIN(SUCCESSORS(column@row),”,”)
This formula, combined with the JOIN function, will calculate the direct successors of a task and return a collection of task row numbers that will occur due to the referenced task.
Set up automation rules to notify assignees their tasks are ready to begin.
Still need help?
Use theFormula Handbook templateto find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.