If Contains


I'm struggling with a formula to check a reference sheet for two conditions. An ID matching and a multi-select cell containing a certain value.

Here's the sheet with the desired results in the Has Blue column.

Here's the reference sheet.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!