Formula Help

Options

I have a formula for RYGB balls based on days open. Here are the criteria I'm trying to achieve:

Done is checked = Blank

Red = 365+ days open

Yellow = 300 - 364 days open

Green = 180 - 299 days open

Blue = 0 - 179 days open

The formula I have is =IFERROR(IF(Done@row = 1), "", IF(ISNUMBER([Days Open]@row), IF([Days Open]@row >= 365, "Red", IF(AND([Days Open]@row >= 300, [Days Open]@row < 365), "Yellow", IF(AND([Days Open]@row > 180, [Days Open]@row < 300), "Green")))), "Blue") but it gives me an incorrect arguement set error.


Can somebody please help figure out what I am doing wrong? Thanks!

Best Answer

Answers

  • Heather K
    Options

    Perfect. I figured it was something simple but couldn't seem to figure it out. Thank you very much!