Daily Notification

edited 12/09/19 in Formulas and Functions

Hi All, 

Is there a way to send a daily notification when a task is not complete? The way my sheet is set up is the RYG dots are automated depending on the due date, and based on those dots, notifications get sent (Yellow is the due date, Red is overdue). 

What I would like to do is once the dot turns Red, to have a notification automatically sent everyday until the task is complete, instead of just once. 

Can Smartsheets do this?


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 02/08/18

    This is possible. I will withhold my answer, because I am hoping the Community has a better solution than what I have.

    (I don't mean to be coy -- it just so happens I have been working on this off and on all day ... and I really hope I missed something)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!