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
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!
Help Article Resources
Check out the Formula Handbook template!