Multiple IF Statements Based On Symbol Color

ANGELAPRIOR

Hello,

I am trying to enter a formula in a column labeled 'Completion Status' that will show either a Red, Yellow, or Green symbol based on the conditions in 12 other columns. Every time I get close by setting 2 criteria, the other final criteria doesn't seem to work out for me. Below is a breakdown of what I am attempting to accomplish:

If all 12 columns = "" (blank), then "Red" in the 'Completion Status' column

If all 12 columns = "Green", OR "Gray", then "Green" in the 'Completion Status' column, otherwise "Yellow" (to denote that this row is still In Progress)

When I try to do multiple IF statements or rearrange the order in which criteria takes precedence over the other, I either get #UNPARSEABLE or #INCORRECTARGUMENT.

Paul Newcome

Are all of those columns next to each other?

ANGELAPRIOR

Hi Paul,

Thanks for replying. The 'Completion Status' is the first column in the grid and the other 12 are all next to one another.

PS (I did also try doing [Column1:Column12] = "Green", then etc., but I ran into trouble that way as well)

Paul Newcome

Give this a try...

=IF(COUNTIFS([Column1]@row:[Column12]@row, @cell = "") = 12, "Red", IF(COUNTIFS([Column1]@row:[Column12]@row, OR(@cell = "Green", @cell = "Gray")) = 12, "Green", "Yellow"))

ANGELAPRIOR

That worked!!!! Thanks so much Paul - I have been fighting with this for over a week. Have a great week!

Paul Newcome

Happy to help. 👍️