Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

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

Answers

  • Community Champion

    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.

    Site faviconCONTAINS Function | Smartsheet Learning Center

    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.

  • Community Champion
    edited 06/09/24

    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!

Trending in Formulas and Functions