If Formula RGY with numbers greater than, less than and zero
Trying to get the RGY to flip based on a number value (Budget Variance). As written, yellow works but the Red and Green don't. Any ideas?
Formula I'm using:
=IF([Budget Variance]@row = "0", "Yellow", IF([Budget Variance]@row = ">0", "Green", IF([Budget Variance]@row = "<0", "Red")))
Thanks in advance!
Best Answers

=IF(ISBLANK([Budget Variance]@row), "", IF([Budget Variance]@row = 0, "Yellow", IF([Budget Variance]@row > 0, "Green", IF([Budget Variance]@row < 0, "Red"))))
I created an IF(ISBLANK(), if not and there are no numbers in Budget Variance, it'll just default to "Yellow"
"Without IF(ISBLANK)"
"With IF(ISBLANK()"
I also got rid of the equal sign for green and red because we already have a statement that equals 0. We're going to need to return colors based on numbers greater than 0 or less than 0.

Try this
=IF([Budget Variance]@row = 0, "Yellow", IF([Budget Variance]@row > 0, "Green", IF([Budget Variance]@row < 0, "Red")))
Answers

=IF(ISBLANK([Budget Variance]@row), "", IF([Budget Variance]@row = 0, "Yellow", IF([Budget Variance]@row > 0, "Green", IF([Budget Variance]@row < 0, "Red"))))
I created an IF(ISBLANK(), if not and there are no numbers in Budget Variance, it'll just default to "Yellow"
"Without IF(ISBLANK)"
"With IF(ISBLANK()"
I also got rid of the equal sign for green and red because we already have a statement that equals 0. We're going to need to return colors based on numbers greater than 0 or less than 0.

Try this
=IF([Budget Variance]@row = 0, "Yellow", IF([Budget Variance]@row > 0, "Green", IF([Budget Variance]@row < 0, "Red")))

Thank you, Community! Both suggestions given worked and I learned from them re: where I was going wrong, really appreciate it!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!