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
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 429 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!