Combing IF AND CONTAINS question


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!!!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!