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

Josh Lowry

Hello,

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"))

Paul Newcome

It looks like you just have one too many closing parenthesis on the end.

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

It also looks like you are using "smart quotes". Notice how the quotes in your formula are slanted to show open vs closed but this set " " of quotes is not slanted? Those slanted ones are "smart quotes" and Smartsheet doesn't accept those.

Retype the the formula directly into your sheet and drop off one of those closing parenthesis. That should get it working for you.

Paul Newcome

It looks like you just have one too many closing parenthesis on the end.

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

It also looks like you are using "smart quotes". Notice how the quotes in your formula are slanted to show open vs closed but this set " " of quotes is not slanted? Those slanted ones are "smart quotes" and Smartsheet doesn't accept those.

Retype the the formula directly into your sheet and drop off one of those closing parenthesis. That should get it working for you.

Josh Lowry

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

Josh

Paul Newcome

Happy to help. 👍️