IF AND Statement for Color Statuses
Comments
-
That got it!
Now it is working exactly as I'd hoped. Thank you very much!
-
-
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.
-
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
-
@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"))))
Help Article Resources
Categories
Check out the Formula Handbook template!