Used within another function to calculate the direct successors of a task and return succeeding task row numbers that occur as a result of the referenced task.
Syntax
SUCCESSORS(value)
- value—The value is typically a cell to evaluate.
Sample usage
= JOIN(SUCCESSORS(Column@row),”,”)
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, calculates the direct successors of a task and returns a collection of task row numbers that occur due to the referenced task.
Set up automation rules to notify assignees they can start working on their tasks.
Still need help?
Use the Formula Handbook template to find more support, resources, view 100+ formulas, 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.