Notification When a Date Changes
I am trying to work with formulas and notifications so that if a person does not change a date in a cell, then they are sent an email reminder. Once they change the date in the cell, they won't be sent the reminder.
In the picture above, somebody will manually enter the Due Diligence Date. The Site Development and Hard Construction cells have a formula so that the date in them is 30 days prior to the Due Diligence Date. These dates that are 30 days prior act as deadlines for when they need to determine the Site Development and Hard Construction costs. When they determine those costs, they will go in and change the date to reflect the date they did this. Ultimately, I need automated reminders to go out to the various people if they have not updated those cells. For each sheet, I will need to create reminders for each date. For this example, just the two. I started playing around with some formulas, but nothing worked correctly.
Any help with this is greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!