Formula to Capture Active Projects Assigned to an Individual ONLY
I'm currently having trouble figuring out how to capture the number of status specific projects assigned to an individual. I've attempted the "COUNTIFS" formula many times, but can't seem to configure it so that it counts the number of projects by assignee IF the project status is one of the following:
Sent for Corrections
The current formula is counting every single project (Completed projects included) we've ever had and our dashboard is receiving a lot of questions due to the large number of project each team member has. Please help!
Help Article Resources
Check out the Formula Handbook template!