We have created a new hire checklist template with a start date cell that drives "due dates" in the sheet. We also created a notification to trigger emails when either "Done" or Due Date" changes are made. Unfortunately, because the notification does not move forward with any new sheets created from the template, we have to create the new notification each time we begin the new document. (This would be a great addition to the programming, btw.)
If the new sheet is created, and the start date is entered (triggering the other due date fields to populate) BEFORE the notification is set up, it appears this notification will not apply UNTIL any NEW changes are made, e.g., a change is made to a "done" task. Is there a way to have the notification apply after the fact, or is it only for forward occurrences?
