Automatic Due Date
This might be a stretch but going to put it out there.
This is my situation. Each manager has a sheet with their individual employees and what cost centers they are projected to work in for the upcoming quarter. They were sent a notification to update the sheet triggered by the date of 2 weeks prior to the due date of the information being needed by finance.
However, since each manager has an individual sheet, (I had to meet them where they were at and compromise), I am trying to avoid having to add in separate notifications for each quarter and would like it to be triggered by a due date column that automatically changes to the upcoming due dates of 1/9, 3/9, 6/9 and 9/9.
Is there a formula that could be used to default the quarterly due dates?
If yes, I feel like I can set up one notification for each that the due date is upcoming and a reminder notification if the data isn't enter 1 week prior to the due date.
Help Article Resources
Check out the Formula Handbook template!