Negative Values to generate logics
Hello,
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

Hey @Vinton Douglas
If a number is enclosed in quotes then smartsheet views it as a textstring, not a numerical value. Remove the quotes from your numbers and your formula should behave as you expect.
Kelly
Answers

Hey @Vinton Douglas
If a number is enclosed in quotes then smartsheet views it as a textstring, not a numerical value. Remove the quotes from your numbers and your formula should behave as you expect.
Kelly

Magic. Thanks a lot.
Help Article Resources
Categories
Check out the Formula Handbook template!