Help with CONTAINS formula

James Yewen

Hi,

I currently have a formula that is looking for a value in one cell and if it matches another it throws out a yes/no.

What I want to do is amend it so it looks for certain text and have it throw out a yes/no if it matches the other cell value.

Formula is: =IF(AND([ILG (min)(mm)]@row <= 0.249, [Finish (Outer plating only)]@row = "Matte Sn"), "Yes - M- Required", "No - Not Required")

I need the [Finish (Outer plating only)]@row = "Matte Sn") section to become a CONTAINS and look for "Sn"

(In the above instance the 'Fine Pitch Coating Req' should be yes)

Any help is most appreciated.

Thanks in advance,

Kaveri Vipat

Hi James Yewen,

You can try the below formula, I hope this works for you.

=IF(AND([ILG (min)(mm)]@row <= 0.249, CONTAINS("Matte Sn", [Finish (Outer plating only)]@row), "Yes - M- Required", "No - Not Required")

 Thank You

Kaveri Vipat, Sr. Smartsheet Engineer, Ignatiuz Software