Alerts
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?
Comments
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives