Notify an assignee that the predecessor has complete his task.

I want to use smartsheet as an international project management tool. One thing is driving me creasy.

I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.

The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done"). If the assigned person of task 25 & 26 marks their tasks as done, the assigned person of task 27 should know that he can start. Via e-mail notification.

This should be a standard scenario that a lot of people have. I couldn't find any good solution in several threads. E.g.:

https://community.smartsheet.com/discussion/notify-assignee-predecessor-required-start-work-has-been-completed

https://community.smartsheet.com/discussion/notify-dependent-task-assignee-predecessor-task-has-been-completed

Is there a new future that I am missing?

The problem always seems to be that the assignee is in another row. You can't make notification rules over different rows. It needs to be something like: If "done" is "checked" notify "assigned to" of the assigned task(s).

I tried to add a column that would give me the name of the assignee but it didn't work out well. I want to avoid typing in the assignee manually for every task.

My user group is not that familiar with tables in general. So I want to avoid doing too much organizational.

I would appreciate any support I can get.

Regards

Alex

Find more posts tagged with

Manufacturing

Sheets

Contacts

Formulas

Marketing

Solution Center

Gantt View

Project Management

Cell linking

Media & Entertainment

Enhancement Request

Email Notifications

Comments

Craig Moss

Here is how I have approached this. I'll try to adapt it to your scenario.

Add checkbox columns [Prereq Task 1] - [Prereq Task 2].

On row 27, enter the formula =Done25 in [Prereq Task 1]. Enter the formula =Done26 in [Prereq Task 2].

Add a checkbox column [Actionable]. On row 27, enter the formula =AND([Prereq Task 1],[Prereq Task 2])

Now, Actionable27 will be checked when the two prerequisite tasks on rows 25 and 26 are Done. You can use this in the conditions to trigger your Alert.

Hope it helps...

Paul Newcome

Unfortunately you have run into a block that has caused much frustration and very minimal "solutions". A lot of tedious and manual work is generally the "solution" to this issue involving manually adjusting formulas for each specific rows. Feel free to submit an enhancement request though as this is DEFINITELY a feature worth having and is in high demand.

https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?_ga=2.88241375.555919786.1553514900-1302373248.1552411124

nate103946

@alexander, were you able to identify a workaround for this?

Brett Shapiro

I have this same issue. Just started using Smartsheet and am honestly surprised this is not a current feature. I found threads bating back to 2016 requesting this capability.

This seems fundamentally basic to me, IE: I have a task, when it's marked complete, notify the assigned to of any task that is linked back to the task as a predecessor.

jwilson10533

My temporary solution is to great a new column called "Inform" (from the RACI framework) of type Contact List and I manually configure those that need notification which more or less mirrors the assigned users to the downstream tasks. If my template is reasonably reliable, then for each instance I create there is minimal downstream modification upon creation.

Tori Isbell

I'm having the same problem and would love to see something to resolve this in an upgrade.

DonaraJaghinyan

has there been a workaround found for this scenario?

Genevieve P.

Hi @DonaraJaghinyan

Since this post, there has been a release of a new formula Function called SUCCESSORS. There are some other threads in the Community that discuss how to use this function to find out if a next task is ready to go.

For example, this testing post which may have some solutions for you:

https://community.smartsheet.com/discussion/84257/successors-testing

Cheers,

Genevieve

DonaraJaghinyan

Thank you Genevieve, you shared such a helpful thread with me.

I asked my question in the other thread.

Sign in to join the conversation!

Quick Links

Trending discussions

Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)
Submitting forms for approval
Any help would be greatly appreciated! We have a 3-step process for travel approvals. I am able to get the forms to the correct people. I now have a request for the ability to add comments during the approval process. Staff submit request via Smartsheet form Automation forwards the form to the manager for approval Once…
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.