At Risk formula help

Farha ✭✭
edited 12/09/19 in Formulas and Functions


I need help with creating a 'At Risk flag' when End Date is reached and Status is not complete. I have tried multiple combinations, can someone please review and help me correct this formula

I am entering on Row4, End Date and Status are columns and Complete is a drop down under the status column.

=IF(AND[End Date]4 < TODAY(), NOT(Status4 = "Complete")), 1, 0)

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!