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
Hello,
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,
Sebastien
Comments
-
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."
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives