To find out how many times the contact is mentioned

Options

Hello,

I know the subject has already been mentioned but I can't solve my problem. Because a cell can contain several contacts.

I am trying to find out how many times the contact "Franck Debucquet" is mentioned in a column.

Sometimes a cell can contain several contacts.

See example below

:


Thanks !

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Christophe AUBRIOT 

    Hope you are fine, please try the following formula:

    =COUNTIFS(Contact:Contact, HAS(@cell, "Franck Debucquet"))

    the following screenshot shows the result


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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"

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Christophe AUBRIOT 

    Hope you are fine, please try the following formula:

    =COUNTIFS(Contact:Contact, HAS(@cell, "Franck Debucquet"))

    the following screenshot shows the result


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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!