Alerts

Jaeven

I wish to have applied alerts to my sheets: 

• Notification 48 prior to a task starting
• Notification on the start date
• Notification daily after end date if task is incomplete 

These notification are all alerting on the start date and not when specified.

The rules i have set on each alert is as follows:

Alert 1:

Based on a date on Start

In any row where Start is in the next (days) 2

and

In any row where Complete is unchecked

Notify Assigned To

Alert 2:

Based on a date on Start

In any row where Start is today

and

In any row where Complete is unchecked

Notify Assigned To

Alert 3:

Based on a date on Finish

In any row where Complete is unchecked

and

Finish is in the past

Notify Assigned To

Again the are sending 3 emails on the date the tasks starts… Can anyone spot an error?

Ella

I think you need a separate column that can be hidden afterwards calculating the date 48 hrs before the Start Date. Then your notification should be Based on that column, where the Start Date is in the next 2 days. I hope this makes sense.