Formula for the automatic display of a symbol


Hi, I would need a formula to automatically display a symbol (red, orange, or green) in a cell depending on the color of symbols from four other cells.


  • If there is a green symbol in each of the four cells, then the fifth cell should display green,
  • If two of the four cells have an orange symbol and the two other ones a green one, the fifth cell should display orange,

Can you help me with that?

Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!