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 .