How to write a RYG formula for a range of values?
I am working on a formula for:
1) If cell is empty = Yellow
2) If cell is between 20 to 20 = Green
3) Otherwise = Red
How should I write this formula?
I am able to get the formula right if it is simpler as follows:
1) If cell is empty = Yellow
2) If cell is 0 = Green
3) Otherwise = Red
=IF(ISBLANK([Cell]@row), "Yellow", (IF([Cell]@row = 0, "Green", "Red")))
Appreciate assistance. Thank you.
Best Answer

Hi @Vivien Chong
Hope you are fine, please try the following formula and convert it to column formula:
=IF(ISBLANK(Amount@row), "Yellow", IF(AND(Amount@row <= 20, Amount@row >= 20), "Green", "Red"))
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers

Hi @Vivien Chong
Hope you are fine, please try the following formula and convert it to column formula:
=IF(ISBLANK(Amount@row), "Yellow", IF(AND(Amount@row <= 20, Amount@row >= 20), "Green", "Red"))
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 359 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!