IF Formula
Hello,
Not sure how to create column formula for the following criteria utilizing RYGB color formatting:
• 029% red
• 3049% yellow
• 5099% green
• 100% blue
Best Answer

The IF() formula can be written to flow exactly as you described/outlined it.
If it's less than or equal to 29%, then Red; if it's less than or equal to 49%, then Yellow; if it's less than or equal to 99%, then Green; else, Blue.
Let's say that the percent complete is in a column labeled "Progress". Your formula would be...
IF( Progress@row <= 0.29 , "Red", IF( Progress@row <= 0.49 , "Yellow", IF(Progress@row <= 0.99, "Green", "Blue" ) ) )
Answers

The IF() formula can be written to flow exactly as you described/outlined it.
If it's less than or equal to 29%, then Red; if it's less than or equal to 49%, then Yellow; if it's less than or equal to 99%, then Green; else, Blue.
Let's say that the percent complete is in a column labeled "Progress". Your formula would be...
IF( Progress@row <= 0.29 , "Red", IF( Progress@row <= 0.49 , "Yellow", IF(Progress@row <= 0.99, "Green", "Blue" ) ) )
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 438 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 451 Show & Tell
 30 Member Spotlight
 1 SmartStories
 283 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!