Trying to calculate a countif and contains a "city"
Hi
I have a sheet that is filled out by staff and another sheet that has a breakdown of % compete for each branch.
The requirement is to calculate how many power users from Calgary have completed the checklist There are 10 members in a Calgary need to find the percent that have completed the power user training.
Was trying this formula:
=COUNTIFS({Wave 6A- Acturis Readiness}, =true) / [Team Members in Group]@row, CONTAINS(Branch1@row,"Calgary")
Any assistance is appreciated.
Answers
-
Hey @Roshni Verappan
To better answer, it would be helpful to have more details.
Is it possible to get a screenshot of the relevant columns of your source sheet? Specifically, does the source sheet reference the Branch? What does the checkbox in the source sheet signify (referenced in your COUNTIFS)?
What do the 10 team members of Calvary represent? Power users?
Kelly
-
Hey Kelly,
Thanks for the quick response but I managed to figure out a formula that worked.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!