IF Statement Check box, not returning check

ShaunaT ✭✭✭
edited 12/09/19 in Formulas and Functions


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?



  • L_123
    L_123 ✭✭✭✭✭✭

    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)


    =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.

  • ShaunaT
    ShaunaT ✭✭✭

    L@123 perfect thank you! That's exactly what I was doing wrong! Fixed!! :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!