Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Select predecessors

edited 12/09/19 in Archived 2017 Posts


I would like to find a way to select rows that are predecessors to an other row. 

I want to to do this in order to create a notifications that sends an email to the person in charge of a task, when the predecessors tasks are finished, so he knows he has to get to work on this task. 

Thank you, 



  • Shaine Greenwood

    Hi Sebastien,

    There isn't a way to notify a user assigned to one task when a predecessor task is finished.

    You might consider adding a dropdown column to your sheet that you can use to set the status of someone's row, such as "Need to Start," "In Progress," and "Complete."

    Then you can create a notification to the assignee when the status on their row is set to "Need to Start."

  • lclarkson

    Is there a way to have the status automatically change once a predecessor is complete?  The only thing I've been able to come up with so far is using additional columns with an if statement on the status of each predecessor and then an if statement in the status cell of the task in question.

This discussion has been closed.