Checking checkbox if the cell on the same row in a different column contains one of several values
Hi all,
I'm currently having a little bit of difficulty writing a formula for a checkbox column. I intend to write the formula so that the box will be ticked if at least one of three values (people's names in this context) appear in a different column on the same row. I can get it to check by only specifying it contains one name but not if it contains one of the three I need.
Any help would be greatly appreciated. Thanks.
Answers
-
Here you go,
The OR, will add multiple logical expressions. That combined with CONTAINS should get you where you want to be.
=IF(OR(CONTAINS("Name1", Name@row), CONTAINS("Name2", Name@row), CONTAINS("name3", Name@row)), 1, 0)
-
Thanks for your reply. That's the formula I'd been working with but it wasn't checking any of the checkboxes. I've now created a new column for the 'name@row' as a text column instead of contact as it had been before and it works. Thank you.
-
Can you share the formula or a screenshot of the issue (with any sensitive info removed)?
I was able to get it working on my end, maybe I am misunderstanding.
-
Yeah I've got it working now. Just don't think it was before since the name column was formatted as a contact.
Thank you.
-
Ah, if it is a contact column then you would use HAS.
=IF(OR(HAS(Name@row, "Name1"), HAS(Name@row, "Name2"), HAS(Name@row, "Name3")), 1, 0)
Glad you got it figured out!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!