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

Paul Newcome

I was thinking something along the lines of just adding another condition to the alert rules.

J. Craig Williams

Yeah, that's better.

Craig

Paul Newcome

You're the one that taught me... Keep it simple.

J. Craig Williams

LOL

That definitely sounds like me.

Craig