SUCCESSORS Function

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 occurred before the next task can begin. Successors are the tasks with a dependency directly after the 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 the Smartsheet Formula Template to view examples and practice working with functions in real-time.

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community