Change a Cell Value (Checkbox)

Tom Collins

I want to change a header row cell value (checkbox) if any of the rows below in another column (in the same worksheet) has check mark or not.

Paul Newcome

In that case just use a full column reference.

=IF(COUNTIFS([Other Column]:[Other Column], @cell = 1)> 0, 1)

Paul Newcome

If you are using indentations/hierarchy then you can use the CHILDREN function inside of a COUNTIFS.

=IF(COUNTIFS(CHILDREN([Other Column]@row), @cell = 1)> 0, 1)

Tom Collins

Thanks, Paul, but the row are not a child of the header row.

Paul Newcome

In that case just use a full column reference.

=IF(COUNTIFS([Other Column]:[Other Column], @cell = 1)> 0, 1)

Tom Collins

Thanks Paul, that worked

Paul Newcome

Happy to help. 👍️