IF Statement Check box, not returning check
ShaunaT
✭✭✭
Hello,
I have a sheet that I am saying if a score is over 80 to check the box. The formula itself seems to be working as it is returning the 1 however I want it to check the box not show me the value.
Any ideas what I'm missing here?
Tags:
Comments

usually you should post the formula you are testing so we know what you did and don't have to guess.
=if([column2]@row > 80,1,0)
also
=if([column2]@row > 80, true,false)
should work.
If it is showing a value my guess is you used the first formula I posted but put the 1 in parenthesis as seen below
=if([column2]@row > 80, "1","0")
which will post the 1 as a text value instead of a numeric value and post the text instead of checking the box.

L@123 perfect thank you! That's exactly what I was doing wrong! Fixed!!
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!