Checking checkbox if the cell on the same row in a different column contains one of several values

harrywhitehouse01 · 06/30/22

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.

Dan W · 06/30/22

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)

harrywhitehouse01 · 06/30/22

https://community.smartsheet.com/discussion/comment/334905#Comment_334905

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.

Dan W · 06/30/22

@harrywhitehouse01

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.

harrywhitehouse01 · 06/30/22

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.

Dan W · 06/30/22

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!

Checking checkbox if the cell on the same row in a different column contains one of several values

Answers

Help Article Resources

Categories