How to count "Contact" cells with multiple contact per cell

There is a contact column where multiple contacts per cell are allowed. How can I count the total number of rows that contain a specific name? Is it possible to combine COUNTIFS & CONTAINS?

=COUNTIFS({Responsible}, {Status}, "NEW", {Responsible}, CONTAINS("Dmitry Gorobets", {Responsible}))

The formula returns 0, but the value should be much bigger. Does CONTAINS formula work with contact columns?



  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Aliaksandr Ilyuk

    Hope you are fine, please try the following formula:

    =COUNTIFS({Status}, @cell = "New", {Responsible}, HAS(@cell, "Dmitry Gorobets"))

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!