IF AND Statement for Color Statuses

RC-MTAS

That got it!  

 

Now it is working exactly as I'd hoped.  Thank you very much!

Paul Newcome

Happy to help! 

RKLRpp

Hope this is an easy fix:

My formula is working but I'm just getting the color words as the formula output "Red" "Green", no harvey balls.

Kelly Moore

Hey @RKLRpp

It sounds like you may have your formula column formatted as a Text/Number column and not a Symbols column. Double click your column header, select Symbols, then choose the harvey balls that match your color designation in your formula.

Does that fix it for you?

Kelly

Kerri S

@Paul Newcome This is a huge help to me. One additional layer - When the status is set to 'Complete', we don't want to change the Status Indicator. The goal is to leave it as is so we can tell if an item Completed Green (On Track), Completed Red (Delayed) or Completed Blue (Ahead). Can you help? Here's my current state: =IF([Jira Epic Status]@row = "At Risk", "Yellow", IF([Jira Epic Status]@row = "On Track", "Green", IF([Jira Epic Status]@row = "Ahead", "Blue", IF([Jira Epic Status]@row = "Delayed", "Red"))))