How to auto-check a checkbox based on a checkbox from a different sheet?

TMK_99

I tried using If(COUNTIFS..) formula but it's not working. How can the results from the checkbox be transfered to a new sheet using a formula? Thank you

Samuel Mueller

@TMK_99 probably need a lot more information but you could try instead

=if(countifs(...)>=1, 1, 0) that would check your box if the countifs matches any criteria.

Assuming you know how to use cross sheet references