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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!