Count if Production is anywhere in the cell.

Options

PDCA range 2 is a drop down list. It is counting it if Production is the ONLY thing selected. If there are multiple things selected, it wont find it in the list and count it. Formula =COUNTIFS({PDCA Range 2}, "Production", {PDCA Range 1}, FIND("OK 3", @cell) = 0)

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Brandon03

    With multi-select dropdown lists, you can use the function HAS to see if the cell has this one specific entry. It looks like your Range 1 is similar, is that correct? I would suggest using HAS in both instances...try something like this:

    =COUNTIFS({PDCA Range 2}, HAS(@cell, "Production"), {PDCA Range 1}, HAS(@cell, "OK 3"))

    Let me know if this works!

    Cheers,

    Genevieve

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Brandon03

    With multi-select dropdown lists, you can use the function HAS to see if the cell has this one specific entry. It looks like your Range 1 is similar, is that correct? I would suggest using HAS in both instances...try something like this:

    =COUNTIFS({PDCA Range 2}, HAS(@cell, "Production"), {PDCA Range 1}, HAS(@cell, "OK 3"))

    Let me know if this works!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!