IF(CONTAINS()) function returns an "Error Unknown function: 'CONTAINS'."

Options

Has this function been removed or is something weird going on with my instance of Smartsheets?

Answers

  • NickStaffordPM
    NickStaffordPM ✭✭✭✭✭
    Options

    Hello,

    This is definitely still a function that is usable, I have linked the Smartsheet article below and have confirmed it is still actively usable.

    https://help.smartsheet.com/function/contains

    Your screenshot of Smartsheet looks super weird to me, its very excel basd vs the Smartsheet I have access to use online and through the App. I wouldn't expect columns to labelled A, B, C, etc… in Smartsheet. Other than that, the formula looks good to me.

    Thanks!

    Nick Stafford

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 06/09/24
    Options

    Hey @BTR214

    The IF statement cannot answer your question as you have asked if "2100" is contained in the entire column. The answer is both true and false.

    Try this (like @NickStaffordPM , I'm assuming your excel sheet is only a mock-up for a smartsheet. If you are working in excel, you might want to ask an excel community elsewhere?)

    =IF(CONTAINS("2100", B@row), "True", "False")

    If you are wanting to determine if "2100" exists anywhere in the column then use a COUNTIFS formula.

    =IF(COUNTIFS(B:B, CONTAINS("2100",@cell))>0, "True", "False")

    Will either of these work for you.

    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!