automatically mark multiple rows when one row is marked

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?

Find more posts tagged with

Accepted answers

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.

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.