Counting number of tasks per Assigned To contact
Hello- I have a sheet that includes a column of assigned personnel per each task of each project. Some tasks have multiple personnel, and I am hoping to be able to get a format where I can visibly see each individual team member and the total number of tasks they have. I went through past discussions, but could not find a solution to what I need. I am hoping to use a formula that will tell me how many tasks each team member has in totality. My goal is to either create a report from this data to display on our dashboard or a graph for our dashboard.
Help Article Resources
Check out the Formula Handbook template!