Notifications set AFTER sheet already created

Pam Tadsen

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?

Travis

Notifications will only be sent out for changes made after the notification was created. If you want to be notified of prior events, you might consider setting up the notification as soon as you create the sheet and before you make any changes.