COUNT by Manager and by Product

Amanda Chu
Amanda Chu ✭✭
edited 12/09/19 in Formulas and Functions

I have a column called "Manager" and Product columns called Product1, Product2, Product3, etc and these are all checkboxes

How can I do a count by Manager of Product? 

Example: 

Joe Smith

  • Product1 - 3
  • Product2 - 10

Jennifer Johnson

  • Product2 - 12
  • Product3 - 5
  • Product5 - 10

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!