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"))
Help Article Resources
Check out the Formula Handbook template!