Alerts for deadlines- Need help

aelmore

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

J. Craig Williams

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