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

Faith

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

@Faith

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

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!