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! 👍️
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives