Automated RYG Based on % Complete Formula Help
Hi,
I'm trying to automate the RYG colored balls so they automatically change colors based on the percent complete entered. I watched a video, read through the suggestions from the community, and was unable to come up with a formula that worked correctly. Can you please help me identify the error in my formula?
When I enter in each element of the formula separately, they work. However, I am unable to combine them successfully.
Separately:
=IF([% Complete]3 = 1, "Green"),
=IF([% Complete]3 <= .50, "Red"),
=IF([% Complete]3 <= .99, "Yellow")
Combined:
=IF([% Complete]3<= 0.50), "Red"), IF([% Complete]3<=0.99, "Yellow"), IF([% Complete]3= 1,"Green")))
Any information you can send me about this #unparseable error is greatly appreciated.
Thanks,
Susie
Best Answer
-
Hi Susy, You have a lot of closing parenthesis that are unnecessary. A nested if statement can't close until the end. Try this revised version. I replaced the row number with an @row identifier which will find the value at that row. You can also make this a column formula by right-clicking on it after you put it in a column.
=IF([% Complete]@row<= 0.50, "Red", IF([% Complete]@row<=0.99, "Yellow", IF([% Complete]@row= 1, "Green")))
For more about @row see:
For more about Column Formulas see:
Answers
-
Hi Susy, You have a lot of closing parenthesis that are unnecessary. A nested if statement can't close until the end. Try this revised version. I replaced the row number with an @row identifier which will find the value at that row. You can also make this a column formula by right-clicking on it after you put it in a column.
=IF([% Complete]@row<= 0.50, "Red", IF([% Complete]@row<=0.99, "Yellow", IF([% Complete]@row= 1, "Green")))
For more about @row see:
For more about Column Formulas see:
-
Thank you so much Mike!! That was the secret!! 😃
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 422 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!