If function for issue flagged

Swamfax

Dear,

I just wrote the below  formula that update the status with RYBG indicators. however, I am having issue with the last if function of the formula "Flag Issue" part. I want the status to change to red when an issue is flagged or checked and it is not working. Can any one please help.

=IF(Status2 = "In Progress", "Green", IF(Status2 = "At Risk", "Red", IF(Status2 = "Complete", "Blue", IF(Status2 = "Not Started", "", IF([Start Date]2 < TODAY(), IF(Status2 = "Not Started", IF([End Date]2 < TODAY(), "Yellow", IF(Status2 = "In Progress", IF([End Date]2 < TODAY(), "Red", IF([End Date]2 > TODAY(), "Green", IF(Issue2 = 1, "Red", "Green")))))))))))

Regards,

 

Michael

jglithero

Seems like you are missing some false conditions.

See this:

=IF(Status2 = "In Progress", "Green", IF(Status2 = "At Risk", "Red", IF(Status2 = "Complete", "Blue", IF(Status2 = "Not Started", "", IF([Start Date]2 < TODAY(), IF(Status2 = "Not Started", IF([End Date]2 < TODAY(), "Yellow", IF(Status2 = "In Progress", IF([End Date]2 < TODAY(), "Red", IF([End Date]2 > TODAY(), "Green", IF(Issue2 = 1, "Red", "Green"), "Red2"), "8"), "7"), "6"), "5"), "4")))))

With nothing in the Status2, it stops at false on number 5.

Hope that helps.

Paul Newcome

What exactly are the criteria you are using for each color?

Swamfax

Many thanks Jglithero. I follow your approach and it worked