Alerts for deadlines- Need help
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.
Help Article Resources
Check out the Formula Handbook template!