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:
- The Task is Unchecked
- 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.