Nested If Formulas with conditions in 2 columns

Jennie O

I'm trying to figure out how to create a formula that has a red flag appear if the following are true. I can't seem to figure out how to put the whole formula together. Any help is appreciated. Thanks!

IF(AND[Due Date]@row < TODAY(), Status@row <> "Complete" 1, 0)

IF(AND([Due Date]@row < TODAY(), Status@row <> “Closed”), 1, 0)

IF(AND([Due Date]@row < TODAY(), Status@row <> “Closed”), 1, 0)

 

Mike Wilday

IF(AND[Due Date]@row < TODAY(), Status@row <> "Complete"), 1, 0)

Try this. You need to close the AND statement and add a comma.