Nested If Formulas with conditions in 2 columns

Jennie OJennie O ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
10/30/18 Edited 12/09/19

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(), [email protected] <> "Complete" 1, 0)

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

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

 

Tags:

Comments

Sign In or Register to comment.