RAG Status based off Number Range



I came up with this formula to define RAG Risk Score based off a number or a range:

Green = Risk Score of 3 or less

Amber = Risk Score between 4 & 9

Red = Risk Score of 10 or more

=IF([Overall Risk Score]1 <= "3", "Green", IF([Overall Risk Score]1 = "4-9", "Yellow", IF([Overall Risk Score]1 >= "10", "Red")))

However, the coloring isn't matching the criteria. Example: a 7.5 is coming up as Red and not Amber.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!