Formula for the automatic display of a symbol

DavCalli

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.

Examples:

• 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,

DC

DavCalli

Solved: created new cells to count the total number of each symbol and then used IF and AND functions to create the different conditions from these new cells.

Andrée Starå

https://community.smartsheet.com/discussion/comment/392987#Comment_392987

Hi,

I hope you're well and safe!

Happy that you figured it out!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!