Formula question

Options

I am struggling with the formula. I need to pull the info from all the cells that contain the "ITEM" and give me the total number. Some cells have multiple items, so when i use the COUNTIFS formula it does not pull the info from the cells with multiple items in it. What formula should I use? I need to take into account e.g. ITEM and COLOR.

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    Hey @akantemirova

    Multiselect columns often need the HAS or CONTAINS function to read all the values within these cells.

    Try this

    =COUNTIFS(whatever range you are using, CONTAINS("ITEM", @cell))

    be sure to replace my <range> with your real range.

    Does this work for you?

    Kelly

  • akantemirova
    Options

    @Kelly Moore

    Hello Kelly. Thank you for the response.

    Here is what I have

    =COUNTIFS({Feature Requests Range 1}, CONTAINS("APAC"@cell), {Feature Requests Range 2}, [Product Priority Level]@row)

    However, it does not work. First I put the range, which is a column, then CONTAINS("APAC"@cell). APAC is the item i need searched for in the cells of the column


    Thank you

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!