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?
Best Answers
-
Try:
=IF(OR([Registered (DL)]@row = 1, [Registered (DPS)]@row = 1), 1
-
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?
Answers
-
Try:
=IF(OR([Registered (DL)]@row = 1, [Registered (DPS)]@row = 1), 1
-
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?
-
Thank you both! I was not even thinking about the OR function. Both are lifesavers.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!