automatically mark multiple rows when one row is marked

Chevon Brownell

Is there a formula to check all the boxes with the same account number when one is checked?

For example, Account 10-111 has 3 owners. When we receive a vote from anyone of them, we will choose the method the vote was received and check a box under the valid or invalid vote columns. Is there a way to cross out all three owners when we mark just one row? Maybe based on the account number?

Mogule

By first glance, I'd go with nested IF statements.

=IF({First Owner Checkbox Reference},1,IF({Second Owner Checkbox Reference},1,IF({Third Owner Checkbox Reference},1,0)))

It'll check the first owner's checkmark, and if it's True (checked), it'll show the box as 1 (Checked). If it's not checked, it'll check the second owners checkbox, etc.

You'll need to change the checkbox column in to a text column to set the formula up, then change it back to checkboxes when you're done.

Mogule

By first glance, I'd go with nested IF statements.

=IF({First Owner Checkbox Reference},1,IF({Second Owner Checkbox Reference},1,IF({Third Owner Checkbox Reference},1,0)))

It'll check the first owner's checkmark, and if it's True (checked), it'll show the box as 1 (Checked). If it's not checked, it'll check the second owners checkbox, etc.

You'll need to change the checkbox column in to a text column to set the formula up, then change it back to checkboxes when you're done.