# Two checkbox columns to drive checkbox in 3rd column.

Options
✭✭✭✭

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?

Tags:

• ✭✭✭✭✭✭
Options

Try:

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

• ✭✭✭✭✭✭
Options

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?

• ✭✭✭✭✭✭
Options

Try:

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

• ✭✭✭✭✭✭
Options

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?

• ✭✭✭✭
Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!