Creating an At Risk Formula

edited 12/09/19 in Formulas and Functions

Hello Community,

I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the check box column and the Due Date is within the next 3 days. I've made several attempts at using an IF/AND formula, but can't seem to get it to work properly. 

Any assistance you can provide would be greatly appreciated! 

Thank You! 

Screen Shot 2019-05-06 at 9.29.00 AM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!