Symbols and Formulas

MeganMcHenry

I am trying to create a formula that will give a column a symbol (red, green, yellow blue) based off of the amounts of colored symbols in the column. Right now in each row, I have associated a symbol based on the task status - the symbols are Red/Yellow/Green/Blue

I want to be able to assign an overall Symbol for the column based on the following logic

Column is Green if there are no reds are yellows

Column is Yellow if there are no reds and 1 or more yellow

Column is Red if there are any reds

Paul Newcome

You would use something along the lines of

=IF(COUNTIFS([Column Name]:[Column name], "Red") > 0, "Red", IF(COUNTIFS([Column Name]:[Column Name], "Yellow") > 0, "Yellow", "Green"))