Nested If formula for RYG
Good morning,
I'm having an issue with the following formula. The red and green come out, but the yellow comes back blank. Any assistance would be appreciated.
=IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row <= 0.07  1, "Yellow", IF([% Complete]@row = 1, "Green")))
Best Answer

I figured out the answer...I changed it to say
=IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row = 1, "Green", "Yellow"))
I tried to find a way to delete my question, but maybe this will help someone else in the future 😉
Answers

I figured out the answer...I changed it to say
=IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row = 1, "Green", "Yellow"))
I tried to find a way to delete my question, but maybe this will help someone else in the future 😉

Thank you for posting your solution! 🙂I'm glad you were able to figure it out.
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions

Thank you for leaving this up! I just used it for an issue I was stuck on and it worked for me!

That's awesome!!! So glad I could help 😊
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.8K 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
Check out the Formula Handbook template!