If Contains

smarterwithsmart

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.

DKazatsky2

Hi @smarterwithsmart,

Give this a try.

=IF(COUNTIFS({ID}, =ID@row, {Color}, HAS(@cell, "Blue")) > 0, "Yes", "No")

Hope this helps,

Dave

DKazatsky2

Hi @smarterwithsmart,

Give this a try.

=IF(COUNTIFS({ID}, =ID@row, {Color}, HAS(@cell, "Blue")) > 0, "Yes", "No")

Hope this helps,

Dave

smarterwithsmart

https://community.smartsheet.com/discussion/comment/403138#Comment_403138

Thank you very much, worked perfectly.