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
 10.5K Get Help
 63 Global Discussions
 66 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!