Changing cell to "0" if checkbox is checked
Options
Comments
-
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
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!