# Multiple IF Statements Based On Symbol Color

Options
✭✭✭

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.

• ✭✭✭✭✭✭
Options

Are all of those columns next to each other?

• ✭✭✭
Options

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)

• ✭✭✭✭✭✭
Options

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"))

• ✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!