If formula with greater/less than
Options
This is probably a fairly basic question, but I'm having trouble creating a formula saying "IF the value of specific column is less than 45 then make column say YES, and NO if greater than 45"
Tags:
Best Answer

=IF([specific column]@row<45,"YES",IF([specific column]@row>45,"NO","VALUE IS 45"))
Tomasz Giba
Answers

=IF([specific column]@row<45,"YES",IF([specific column]@row>45,"NO","VALUE IS 45"))
Tomasz Giba

@Tomasz Giba, thank you!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!