I'm creating an offboarding checklist sheet which sends out automation notifications to relevant parties in each department. Notifications are sent out when the termination goes live, one week after the termination date (if that department's tasks still aren't checked off as done), and two weeks after the termination date (in the same scenario).
Is there a way to make a notification get sent out daily, when the date is more than two weeks in the past, and the box still isn't checked?
Examples of what I already have in place are below.
Initial Notification:
2 weeks overdue:
