Trying to calculate a countif and contains a "city"



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.


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    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?


  • Roshni Verappan
    Roshni Verappan ✭✭✭✭

    Hey Kelly,

    Thanks for the quick response but I managed to figure out a formula that worked.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!