Counting Unique Employees

Nasir@EBC ✭✭✭
edited 01/21/20 in Formulas and Functions

Hi All

I collect data from the staff in the following form:

|| Date || Employee Name || Task || Units Done || Time Taken ||

I want to write a formula that answers the following question:

How many unique employees worked on "Task X"?


I will be formatting the result sheet as:

Task Name -------------- Unique Employee Count

Task A -------------------------------17

Task B -------------------------------19

Task X --------------------------------34

and so on...

Please help!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!