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