IF Formula
Hello,
Not sure how to create column formula for the following criteria utilizing RYGB color formatting:
• 0-29% red
• 30-49% yellow
• 50-99% 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!