I would like to count the total values from a multi select column, based on another columns criteria

Jeremy J.
Jeremy J. ✭✭
edited 07/28/23 in Formulas and Functions

I apologize but I cannot seem to wrap my head around this.

My goal is to count the total values in a multi select column based on another columns criteria.

I figured I could combine the use of CountM and CountIFS but I have not been successful.

Here is an example.

The goal is for me to determine the total # of Reps Per Manager.

There are about a 400 unique Reps, this is just a cleaned up example.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!