Send automatic reminder emails when due date is 1 day away

Hi all - rookie here!

I am trying to set up a table of tasks and due dates.

Here is my setup:

I’d like to set up an automatic emails to go out to the person in the Responsibility column, when the following conditions are met:

  1. The Task is Unchecked
  2. The Due Date is one day before and/or the actual due date listed.

I feel like this is a super easy formula, but I am at a loss for where to being. Do I need to create a button column? What if I wanted to send an ah-hoc reminder as well? How would I set that up.

Appreciate the (patience) and feedback. Thx all.

Dear @stazpoe, welcome to the community :handshake:

The below picture shows how you can achieve the conditions you set and in the column 1&2= true is showing when these rules are met.

DueDate-1 = Today() → DueDate-1 is “yesterday”

Dense followup question: how and where do I set this up?

Do I need to add columns and hide? (When I say I am a rookie, I mean I really do need a step-by-step breakdown. :sweat_smile:)

Hi @stazpoe ,
don’t worry: you’ll see that the progress from rookie to expert will be quite fast :wink:

Yes: what @Jean_Pierre_Traets was suggesting was to set hidden columns with the logic for the notification.

Perhaps, if you could share your document (or a sample of it), it’s easier to directly play with it and provide some more deep explanation.

Cheers!