formula - contains


hi Guys i am trying a contains formula but doesn't want to work - what am i doing wrong?

i need my REF column to get a 1 in if IF Dept contains REF if not REF then blank

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Sue van Niekerk

    It looks like you just have a closing parentheses in the wrong spot! You'll want to "close off" the CONTAINS function before moving on to the rest of the IF statement.

    I will note that although CONTAINS should work, the HAS function is built specifically for searching multi-select dropdown cells.

    Try this instead:

    =IF(HAS(Dept@row, "NIS"), "True")




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!