Multiple IF Statements Based On Symbol Color
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.
Help Article Resources
Check out the Formula Handbook template!