check box formula


Hello I am trying to do the following on my smartsheet. I have two columns : the first one with a checkbox format and the next column indicating the % completed.

I want to create a condition such that, if the check box is ticked, the % complete indicates 100% else 0%(if not ticked).


I used the following equation: IF(COL1 = 1, 100%, 0%). However it is not getting parsed.

Kindly let me know if this is the right way to go about .


Thank you