RYGB Based on Status and End Date

misohungry78

I know this question has been asked before (and I also Googled it), but I'm having a difficult time trying to create the RYGB balls.

Can someone help me? I put together the matrix (see below):

Kelly Moore

hey @misohungry78

Try this

=IF(ISDATE([End Date]@row), IF(Status@row = "Completed", "Blue", IF(AND([End Date]@row >= TODAY(), OR(Status@row = "In Progress", Status@row = "Not Started")), "Green", IF(AND([End Date]@row = TODAY(-1), OR(Status@row = "Not Started", Status@row = "In Progress")), "Yellow", "Red"))))

Will this work for you?

Kelly

misohungry78

Thanks, Kelly. Just tried it and the RYGB colors aren't changing, even when I play around with the end dates?

Kelly Moore

Hmm. They changed as I tested all scenarios. Are you getting an error or no color change? Is the date column I named the correct one in your sheet?

misohungry78

Hi Kelly, so sorry to respond so late. I am not getting any color changes. Yes, the date column is correct