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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!