Combing IF AND CONTAINS question

ScionoftheNight

Hi, I have two sheets that I am working with.

Both Sheets have a "Sales Order" Column. The Master Sheet has additional letters typed into the Sales Order Column, while the second sheet is missing those letters. The Master Sheet also has a checkbox.

For the Second Sheet, I am trying to get this checkbox working as well, except I am using the CONTAINS formula.

I have been doing:

=IF(AND(CONTAINS(SO@row, {Sales Order}), {Clonal?} = 1), 1)

My thought for the second sheet is if the Sales Order column contains the same text that is in the Master Sheet Column, and the Checkbox in the Master Sheet is checked, then the second sheet Sales Order row will also be checked. I can't figure out what I am doing wrong with my formula. Could someone please help? Thanks!!!

ScionoftheNight

Ah never mind I figured it out with:

=COUNTIFS({Sales Order}, CONTAINS(SO@row, @cell), {Clonal?}, =1)

ScionoftheNight

Ah never mind I figured it out with:

=COUNTIFS({Sales Order}, CONTAINS(SO@row, @cell), {Clonal?}, =1)

Genevieve P.

Hi @ScionoftheNight

Thanks for sharing your solution with us! 🙂