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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives