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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!