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.

Notify assigned to that task is now ready for their work to begin

I have a product development sheet with dependencies and what I am envisioning is that when the predecessors to a particular task are completed and the task is now ready to work on, the row is emailed to the assignee.  For example, internal testing has been completed so we can now submit for certification.  Email Jerry to let him know that he's good to go with this task to submit.

 

How can this be done in SmartSheet?

 

Thanks in advance

Comments

  • Travis
    Travis Employee

    This could be done with reminders! Reminders are automatic emails that are sent to remind users of tasks assigned to them. As long as the end date of the preceding task is updated upon completion, this will work. 

     

    Here's an example:

     

    In this example, Sub-task 2 is dependent on Sub-task 1, which means the Sub task 2 start date is one working day after the end Sub-task 1 end date (and will change with Sub-task 1 changes). 

     

    So, set a reminder that says "Send whoever is assigned to a task, an email on the start date for their task". As long as the end date remains up to date (if a task is completed early or late, change the date to reflect that) then each user will get an email reminder on the correct start date of their tasks. 

     

    Screen Shot 2015-08-12 at 4.00.28 PM.png

  • Jake,

     

    This exact problem can be solved using Azuqua, an integration partner of Smartsheet. I work for Azuqua and the conditional notification scenario you referred to is one of the many scenarios we enable inside of Smartsheet.

     

    Using Azuqua you can set up a monitor for a change either to a row, column, discussion or new row added to a sheet and then send a notification to a person assigned to that row. The notification can also be based on matching a specific condition of a cell inside that row as well.

     

    If you want to learn more please visit our app listing at Smartsheet here:

    https://www.smartsheet.com/apps/azuqua

     

    Please feel free to follow up with any questions.


    -Patrick

  • $250 per month for conditional notifications (Azuqua Basic Plan)! This is something that should be built into smartsheets. It really shouldn't be that hard.

  • Hi Thor-- To confirm, Conditional Notifications is an ongoing project here at Smartsheet and we're hoping to release the first phase of this product improvement shortly! In the meantime, however, we're happy to help interested customers connect with third party applications like Azuqua and Zapier that can help provide some of this functionality. 

  • Shaine Greenwood
    Shaine Greenwood Employee
    edited 09/16/16

    Hi All,

     

    As mentioned, we're actively working on this feature. If you have ten minutes to spare, we'd love to get your participation in a usability study we're running.

     

    For more information, see this annoncement:

    https://community.smartsheet.com/announcement/weigh-smartsheets-next-strategic-feature

     

This discussion has been closed.