Sheet Summary Formula
I have a formula question that I’m hoping you can help me with. I have a multi-select drop-down in the Stakeholder Department(s) column, which contains several department names. I’m trying to create a sheet summary that counts the number of times any one of these department names appear in that column. I’m currently using the following – and it’s not working. (It looks like it might only be counting the first entry in each cell in that column.) =COUNTIF([Stakeholder Department(s)]1:[Stakeholder Department(s)]35, "Business Ops.") Any advice on how to achieve this?
Answers
-
Hello @Seatora
Hope this finds you well. Try this:
=COUNTIF([Stakeholder Department(s)]:[Stakeholder Department(s)], "Business Ops")
-Peggy
-
I am trying to do something similiar. The fomula seems to count the occurance if is the only value listed. My Concern column allows for mutliple values. =COUNTIF(Concern:Concern, "No call no show")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!