Creating an At Risk Formula


Hello Community,

I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the column that says complete, and the Due Date has been exceeded by 5 days. I've had headaches trying to figure this out.

I would be very grateful for any assistance you can provide with the IF formula which seems to be the formula to apply in this situation! 

Thank You! 

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!