Nested IF (AND (OR))) Formula for Flagging

astra_teller

Hi there,

 I want to be able to flag a column based on a "Status" and not by using a "% Complete" column. I want to flag a row/task that is <= 3 days from an "End Date" column value and IF that "Status" if "Not Started" OR "N/A" OR "In Progress. The formula I've come up with is :

=IF(AND([End Date]@row < TODAY(3), (OR(Status@row ="Not Started",(Status@row = "In Progress",(Status@row = "N/A"))))),1, 0)

Still doesn't work . Any help would be greatly appreciated. 

 

-Astra

Paul Newcome

You have too many parenthesis in your OR statement.

 

Try adjusting so it looks more like this...

 

=IF(AND(this is true, OR(this is true, this is true, this is true)), "Output")

astra_teller

Ahhh I was SO close. Thank you! 

Paul Newcome

Happy to help!