Remove checkbox on select rows

Options

I was exploring some Smartsheet templates and found a unique feature in the below template set.

In the sheet they were able to remove checkboxes in the "Done" column by typing anything other than a 1 or 0 in that cell.

I tried to replicate this behavior in my own sheets and was unable to do so. When I type anything into the checkbox cell on my sheets the text remains. I checked the conditional formatting and there is also no rule that is re-coloring the text either.

Any idea how this was accomplished and if it can be used outside of this template?

Best Answer

Answers