Two checkbox columns to drive checkbox in 3rd column.

I have a pair of checkbox columns, which you can check for different criteria. I have a third column, also a checkbox column.

I am trying to have the 3rd column be checked based off one of the 2 preceding columns being checked.

I tried a formula "=COUNTIFS([Registered (DL)]:[Registered (DL)], 1, [Registered (DPS)]:[Registered (DPS)], 1, false)" which didn't work.

Any assistance?

Find more posts tagged with

Formulas

columns

Accepted answers

Nic Larsen

Try:

=IF(OR([Registered (DL)]@row = 1, [Registered (DPS)]@row = 1), 1

KPH

Hi @Jason F

Your countifs formula will be counting where BOTH things are true. As you only want to check the 3rd box if one or other box is checked, I would use an IF and OR function:

=IF(OR([Registered (DL)]@row = 1, [Registered (DPS)]@row = 1), 1)

This means

IF [Registered (DL)]@row is checked,

OR [Registered (DPS)]@row is checked,

then return 1, (which checks the box).

Does that help?

All comments

Nic Larsen

Try:

=IF(OR([Registered (DL)]@row = 1, [Registered (DPS)]@row = 1), 1

KPH

Hi @Jason F

Your countifs formula will be counting where BOTH things are true. As you only want to check the 3rd box if one or other box is checked, I would use an IF and OR function:

=IF(OR([Registered (DL)]@row = 1, [Registered (DPS)]@row = 1), 1)

This means

IF [Registered (DL)]@row is checked,

OR [Registered (DPS)]@row is checked,

then return 1, (which checks the box).

Does that help?

Jason F

Thank you both! I was not even thinking about the OR function. Both are lifesavers.

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.