Trying to see how many projects are assigned and how many are assigned as initiative resource

Goodie3133

I have a project sheet that I need to pull into a dashboard and show the count for each project manager that are primary then also show how many they are secondary for. I am having issues because I have multiple contacts both boxes, and need each time their name appears to count towards their total projects.

Ultimately need everything to go to the dashboard -

Any help would be so appreciative - currently using this formula and has you can see Andrew is still blank -

Eva

@Goodie3133 You just need to add a bit to your formula. Before entering the name, enter the following:

HAS(@cell, "Andrew Erwin")

That should do it.

Eva