How can I send automatic daily reminders starting 3 days after a deadline has been missed?

I have an automation set up that asks an individual for an update by a certain deadline each time I trigger it.

In case the individual misses the deadline, I'd like automatic reminders to be sent daily starting 3 days after the missed deadline.

Is this possible/how can I do this?


  • JamesB
    JamesB ✭✭✭✭✭✭


    I would create a helper column with a formula something like this...

    =If(AND(Status@row<>"Complete",Today()-[Deadline Date]=>3),Today()," ")

    You can then use an automation to trigger off this cell when it changes.

  • SteyJ
    SteyJ ✭✭✭✭✭✭
    edited 11/10/23

    Hi @Faith !

    You can do this by setting up a checkbox helper column.

    Your formula would look something like

    =IF(AND(Status@row <> "Complete", Deadline@row <= TODAY(-3)), 1, 0)

    Then, you can setup automation to run daily for the row if the checkbox is selected.

    Hope this helps!


    Jacob Stey