Problem using countif to find second contact in the same field....
I have a column where I can add contacts from our integrated address list.
When I use "countif" to count the number of times a contact appears in the column, it works fine if only one contact is listed in the fields in the column.
If I add a second contact to some of the fields in the column and try to use "countif" to count those second contacts, it returns a "0".
For instance if the field contains "John Doe, Jane Doe", the countif can be used to count the number times of John Doe appears in the column, but a similar countif looking for "Jane Doe" returns a "0", even though the second contact is separated by a comma.
Any ideas welcome.....
Answers
-
Try this one out:
=COUNTIF([Contact Column]:[Contact Column], HAS(@cell, "Bob John"))
Sincerely,
Jacob Stey
-
Thank you!
-
Hello @JWood -
Try the following formula:
=COUNTIFS([Contact Field]:[Contact Field], FIND("Jane", @cell) > 0)
Linda
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives