COUNT function for Contact Lists
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
-
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
-
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)
-
Oh good golly! COUNTIF not COUNT. What a Rookie mistake, thank you!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!