I need help with a formula to count how many Associates is under each manager.
I am working on a project where we have around 25 managers who has over a 100 associates, I need to figure out how many associates are under each Manager.
Manager/ Associate Name/ Manager Headcount
Thanks !!
Best Answer

Assumption: Sheet 1 has Manager and Associate Name as 2 columns wherein each row has a Manager for a given Associate; You have unique Manager names in Sheet 2 (not mandatory but I am just assuming)
In Sheet 2 the formula will be:
=COUNT(COLLECT({Associate Name Range in Sheet 1}, {Manager Range in Sheet 1}, Manager@row ))
Answers

Assumption: Sheet 1 has Manager and Associate Name as 2 columns wherein each row has a Manager for a given Associate; You have unique Manager names in Sheet 2 (not mandatory but I am just assuming)
In Sheet 2 the formula will be:
=COUNT(COLLECT({Associate Name Range in Sheet 1}, {Manager Range in Sheet 1}, Manager@row ))

Thanks this worked perfectly!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!