Calculating the number of times a contact name appears in a list

Hello Community,


I'm trying to calculate the number of times a contact name appears in a list, I've used =CountM, =Count, =Find, =Sum but in the end i keep getting 'error'. Please help!

Best Answer

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    Answer ✓

    Ah!

    Your contact column is a multiselect. So we'll need to modify the formula to allow for that...

    =COUNTIF([Contact Column]:[Contact Column],HAS(@cell, "Kate Condon"))


    We use the HAS function for multiselects.

    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!