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.:

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.





  • Craig Moss
    Craig Moss ✭✭✭✭✭✭
    edited 03/27/19

    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
    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.


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

  • 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
    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
    Tori Isbell ✭✭✭✭✭✭

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