Changing cell to "0" if checkbox is checked

Sarah.Humpal82041 · 03/15/19

Wondering if it is possible to change a cell to "0" if the checkbox is checked. I'm assuming a formula will need to be used since I was unable to find it in the conditional formatting.

Thank you for your help in advance.

L_123 · 03/15/19

checkboxes are referred to as 1 (checked) or 0 (unchecked)

Conditional formatting will not change the value of anything, only the format.

your formula will be an if statement similar to below

=if([Column2]1 = 1, 0,"")

https://help.smartsheet.com/function/if

Changing cell to "0" if checkbox is checked

Comments

Help Article Resources

Categories