Trouble with RYG Formula:
Comments
-
=IF([% Complete]3 < 50, "Red", IF([% Complete]3 = 100, "Green, IF([% Complete] >50 AND <100, "Yellow")
Corrected spelling error!
-
Smart sheet displays the percentages as such, but in reality the backend is reading a decimal. When referencing perecentages in formulas you should use .5 for 50% and 1 for 100%. SO your formula would look like this...
=IF([% Complete]3 < .5, "Red", IF([% Complete]3 = 1, "Green, IF([% Complete] >.5 AND <1, "Yellow")
-
Thanks Mike, but there is still something wrong: unparseable!
I have tried a dozen times with the same results!
-
Duh I should have looked more carefully!
And statements should be made as indicated below...
=IF([% Complete]3 < .5, "Red", IF([% Complete]3 = 1, "Green, IF(AND([% Complete]3 >.5, [% Complete]3 <1), "Yellow")))
You also didn't have enough closing parenthesis.
-
Maybe I have been staring at this too long! It still doesn't work. Did it work for you?
YOU are a peach, by the way. Thanks for helping.
-
Are you getting unparseable still?
-
=IF([% Complete]3 < .5, "Red", IF([% Complete]3 = 1, "Green", IF(AND([% Complete]3 >.5, [% Complete]3 <1), "Yellow")))
Green was missing a closing quotation mark!
-
Yes
#baldfromtearinghairout
-
Did this one work?
=IF([% Complete]3 < .5, "Red", IF([% Complete]3 = 1, "Green", IF(AND([% Complete]3 >.5, [% Complete]3 <1), "Yellow")))
Green was missing a quotation mark!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 150 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!