Formula Help
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

Give this one a go. It is going to be shorter than your original formula. The main reason is that if you nest your IF's in a specific order, you don't have to use the AND function to specify that it is between two certain numbers.
If you have "greater than or equal to 365" followed by something else, if it makes it to that "something else" then it is automatically assumed to be less than 365 because that first bit was already found to be false.
=IFERROR(IF(Done@row = 1, "", IF([Days Open]@row >= 365, "Red", IF([Days Open]@row >= 300, "Yellow", IF([Days Open]@row >= 180, "Green", IF(ISNUMBER([Days Open]@row), "Blue"))))), "Blue")
The actual error you are receiving is because of an extra parenthesis. The closing parenthesis here needs to be removed.
IF(Done@row = 1), "",
changes to
IF(Done@row = 1, "",
Answers

Give this one a go. It is going to be shorter than your original formula. The main reason is that if you nest your IF's in a specific order, you don't have to use the AND function to specify that it is between two certain numbers.
If you have "greater than or equal to 365" followed by something else, if it makes it to that "something else" then it is automatically assumed to be less than 365 because that first bit was already found to be false.
=IFERROR(IF(Done@row = 1, "", IF([Days Open]@row >= 365, "Red", IF([Days Open]@row >= 300, "Yellow", IF([Days Open]@row >= 180, "Green", IF(ISNUMBER([Days Open]@row), "Blue"))))), "Blue")
The actual error you are receiving is because of an extra parenthesis. The closing parenthesis here needs to be removed.
IF(Done@row = 1), "",
changes to
IF(Done@row = 1, "",

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

Happy to help! 👍️