Help with CONTAINS formula

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,

Answers

  • Kaveri Vipat
    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

    Thanks,

    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!