A checkbox is an input with underlying values. Formulas can fail when a sheet assumes TRUE and FALSE but the checkbox rule uses custom text instead.
Inspect the checkbox rule
On a computer, select the intended cells and use Insert > Checkbox to add standard checkboxes. For an existing checkbox, inspect Data > Data validation before changing its behavior.
Standard checked and unchecked states use TRUE and FALSE. Google also supports custom checked and unchecked values. For example, a rule can store Yes for checked and No for unchecked, which changes what formulas need to compare.
Match formulas to the stored values
Test one checked and one unchecked cell in a helper area. If the rule uses custom values, compare against those exact values rather than assuming a Boolean expression will behave identically.
Changing the rule across a live range may affect formulas, filters, or charts that consume it. Keep the original configuration and inspect existing entries; do not interpret an invalid or empty cell as a completed task just because the column normally contains checkboxes.
Verify the workflow, not just the icon
Toggle a test checkbox and confirm the relevant result changes in the expected direction. Then test the unchecked state and any intentionally blank row. Check whether copied cells retain the validation rule or only a displayed value.
Removing checkboxes and deleting cell content are different maintenance goals, so choose the operation carefully and retain a recovery point. A checkbox does not establish who approved a task or provide a complete audit record. For approval-sensitive work, combine clear permissions and an appropriate change-history process with the visible control.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.