IF/AND/OR formula help

Liana Weitz

I currently have a formula that works that checks the red flag if either of these two situations are present; 1. the end date is prior to the start date; or 2. the end date is more than 4 years from the start date. This is the formula:

=IF([Target End Date]@row < [Target Start Date]@row, 1, IF(AND(OR(NETDAYS([Target Start Date]@row, [Target End Date]@row) >= 1461, 1, 0))))

I would like to add an AND condition where the Status@row <> "Closed" so that if either of the previous two conditions are true, but the status is Closed, it will uncheck the red flag. I don't need to see the flag if the item is now closed.

Paul Newcome

The easiest way to do this is to just wrap the whole thing in another IF.

=IF(Status@row <> "Closed", original_formula)

Paul Newcome

The easiest way to do this is to just wrap the whole thing in another IF.

=IF(Status@row <> "Closed", original_formula)

Liana Weitz

That worked beautifully! Thank you!!