Counting Items mentioned once in a multi drop down option

How do I have on a tracking sheet where as long as the item is mentioned in a multi choice cell, it counts that item I am requesting? "At Risk Associate" needs to show 4 times, but doesn't show anything. I use COUNTIFS and tried HAS but nothing has worked.


Answers

  • Hi @Austin Whisenant

    COUNTIF and HAS would be exactly what I would do in this situation. Are you receiving an error, or an incorrect count? It would be helpful to see the formula you tried and a screen capture of your sheet, but please block out any sensitive data.

    Here's an example of the COUNTIF and HAS together, in a cross-sheet formula, using @cell:

    =COUNTIF({Referenced Column}, HAS(@cell, "Criteria"))

    The "Criteria" could either be built into the formula "like this", or it could be a referenced cell [Like this]@row.

    You could add other criteria in a COUNTIFS as well, if you'd like:

    =COUNTIFS({Referenced Column}, HAS(@cell, "Criteria"), {Other Column}, "Other Criteria")

    Let me know if you still need help!

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!