Alerts for deadlines- Need help
Hi!
I am trying to set up an alert for deadlines, but only if a box is checked- not for the whole sheet. So people can basically choose- yes, I want alerts for my deadlines, or - no, I don't want alerts for my deadlines.
Right now I have a check box column set up- yes and no. So, I want it so that If the person checks the yes box, the "owner" column will be sent a notification on the "Date1" column. If the person checks the no box, no notifications will be sent.
Some rows the owner will want the notifications, and some rows they won't. So I can't just alter the "owner"s account notification settings.
Any ideas?
Thanks!
Amy
Comments
-
Yes. You'll need a second new Date type column (I call mine [Reminder Date])
=IF(Owner@row, [Date1]@row)
or something like this based on your image
=IF(Owner@row, [BCC Ad Deadline]@row)
and set up a Reminder type Alert on the [Reminder Date] column.
The date will be blank the [Owner] row is unchecked.
I hope this helps.
Craig
-
I was thinking something along the lines of just adding another condition to the alert rules.
-
Yeah, that's better.
Craig
-
You're the one that taught me... Keep it simple.
-
LOL
That definitely sounds like me.
Craig
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!