Alerts for deadlines- Need help

edited 12/09/19 in Formulas and Functions


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? 




Screen Shot 2018-09-15 at 9.36.49 PM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!