Counting unique names in the assign to column

I have the following project sheet. I would do a summary sheet that count the number of unique resources in the assigned to line item/task and then list it out for me.

The comprised data would have the following columns in it.

Assigned Name # of tasks

Jose Garcia 2

Brian Valania 1

Bharath 3

Then i could used the summary data for a chart.

any thoughts on the formula to use. I know I will need to setup a reference


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!