COUNT function for Contact Lists

Options

I am trying to write a formula to Count the number of Rows assigned to specific people. The column I'm referencing is a Contact List and the outcome is providing a value that is incorrect. Is there a different way to write the formula?

I'm doing a COUNT, choosing the Contact List column and then using the contact list name in the quotes.

=COUNT({Product Backlog - Q360 Range 2}, "Dave Hoffmeister")

Best Answer

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    Answer ✓
    Options

    Try this: =COUNTIF({Product Backlog - Q360 Range 2}, FIND("Dave Hoffmeister", @cell) >= 1)

    or this if you want to point to the name in the contact list without typing each:

    =COUNTIF({Product Backlog - Q360 Range 2}, FIND([Insert Contact Column Name]@row, @cell) >= 1)

Answers

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    Answer ✓
    Options

    Try this: =COUNTIF({Product Backlog - Q360 Range 2}, FIND("Dave Hoffmeister", @cell) >= 1)

    or this if you want to point to the name in the contact list without typing each:

    =COUNTIF({Product Backlog - Q360 Range 2}, FIND([Insert Contact Column Name]@row, @cell) >= 1)

  • SShayes
    SShayes ✭✭
    Options

    Oh good golly! COUNTIF not COUNT. What a Rookie mistake, thank you!!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!