IF formula doesn't work?



I am using an IF formula to generate numbers but it doesn't seem to work when i have numbers over 10,000 and it just spits the same number back out. See below:

the formula I am use is: =IF([column 1]@row >= 6500, "6,500", [column 1]@row)

so I'm trying to get it to say if column 1 is over 6,500 then only write 6,500 but any number under it should be the same as the one in the first column.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!