Checking checkbox if the cell on the same row in a different column contains one of several values
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.
Help Article Resources
Check out the Formula Handbook template!