I want to count the number of times a contact appears in a column, how do I do that?
So, I started with =COUNTIF(Name:Name), FIND("John Smith", @cell) > 0) this produced #unparseable. My ultimate goal is to have a dashboard that will display a pie chart with total number of leads per person. Thanks for any help!
Best Answer
-
The COUNTIF function is all you need
=COUNTIF([Name]:[Name], "John Smith")
So you don't have to keep retyping the formula
=COUNTIF([Name]:[Name], [Name]@row)
But really the PIE chart functionally will do this without any formula. Just point it at the name and it will do that out of the box
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
Answers
-
The COUNTIF function is all you need
=COUNTIF([Name]:[Name], "John Smith")
So you don't have to keep retyping the formula
=COUNTIF([Name]:[Name], [Name]@row)
But really the PIE chart functionally will do this without any formula. Just point it at the name and it will do that out of the box
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
-
@Brent Wilson perfect! Worked great. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!