Formula Help for IF/And/Or

I'm trying to write a formula which sets the At Risk Flag.

If the Status="At Risk" the flag should be set

Or

If the End Date is Greater than Today AND the Status is not equal to "Complete" the Flag should be set.

Otherwise, the flag should not be set.


Here's what I came up with. It works correctly when the date is after today and the status is not equal to complete, but the flag does not set if the status is changed to At Risk.

=IF(AND([End Date]@row < TODAY(), NOT(Status@row = "Complete")), OR(Status@row = "At Risk", 1, 0))

Any help is appreciated!

Ed

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!