Negative Values to generate logics



As far as I am aware, -40 is less than 0. I am trying to use a nested IF formula to generate green bubble if Temp <= "-40". This means -40, -41, -42... should generate green bubble. On the other hand -39, -38, -37 ... should generate red. I tried the following formulas but its not returning the correct status:

IF([Temperature (F)]@row >= "-40", "Green", "Red")

IF([Temperature (F)]@row <= "-40", "Green", "Red")

Is there something specific with the generating the correct logics for negative numbers?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!