Formula
Hi Community. I have what I believe is a simple formula question, but I have honestly just about everything. In short, I have a Sheet with an Assigned To Contact List column where they value may be a single person, or multiple names. I am trying to count the number of times per individual. Such as, I many time within the Sheet and the Assigned To column is Billy Bob, Susan Smith, etc.
Best Answer
-
The + "" will convert the cell value to a string that's eligible for a comparison of the CONTAINS function.
Happy to help.
Gia Thinh Technology - Smartsheet Solution Partner.
Answers
-
Hi @Bruce Case
Please try using the following formula. In it, I want to count the number of times the name "Gia Thinh Co." appears in the Assigned To column. The expected result is 4.
=COUNTIFS([Assigned To]:[Assigned To], CONTAINS("GIA THINH Co.", @cell + ""))
Hope it works for you.
Gia Thinh Technology - Smartsheet Solution Partner.
-
Thank you! That worked. I was missing the + "" after the @cell at the end.
-
The + "" will convert the cell value to a string that's eligible for a comparison of the CONTAINS function.
Happy to help.
Gia Thinh Technology - Smartsheet Solution Partner.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives