Countifs function when there are multiple contacts in a cell
Hi Smartsheet Team,
I have a question. I try to use "Countifs" function when there are multiple contacts in a cell. For example, I use cross sheet reference and need to count how many times each person is indicated in the "Assigned to" column. There are multiple team members indicated under "Assigned to" column.
My current formula is as follows:
=COUNTIFS({Smartsheet Range 1}, CONTAINS("Person A", @cell))
Unfortunately, this formula does not work in my case.
Hope for any advice.
Thanks.
Kind regards and have a great day.
Best Answer
Answers
-
I sometimes have better luck with HAS
=COUNTIFS({Smartsheet Range 1}, HAS(@cell, "Person A"))
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives