Formula to Change RYG Status Ball if One or Another Cell Values is Set


I'm trying to figure out the right formula to change the RYG status ball depending on the status set in two different cells. I've tried various IF and OR combinations referenced in community threads but am missing something.

Here's my column info:

Column 1: Engagement

Column Status to trigger Red status ball: Left Company

Column 2: Last Contact

Column Status to trigger Red status ball: More Than One Month

My RYG column is titled: Flags

I want the Flags column to show the Red status ball if either the Engagement column or the Last Contact column are set to either status above.

I've tried multiple variations of this formula to no avail:

=IF(OR(Engagement1 = “Left Company”, [Last Contact]1 = “More Than One Month”), "Red"))

Best Answer


  • That did it! I had tried removing the closing parenthesis earlier but didn't realize I had smart quotes in my formula. Thanks Paul!


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help. 👍️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!