Yellow RAG Formula: Between 2 Numbers (Greater Than Less Than)


Greetings Smartsheet Community:

I Need to Add a Range in my Formula Between -9 & -1 to Turn Yellow. Thanks

Current Formula:

=IF(OR([Schedule Variance]@row > 0, [Schedule Variance]@row = 0), "Green", IF([Schedule Variance]@row <= -10, "Red"))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!