Paul said:
Hi all,
Newbie question: How can I show the number of resources working on a task
or a project? Built-in feature or a special formula? Tried the =counta
Excel function without any success.
Thanks.
Paul
Paul,
There is no specific built-in field for that data and I can't think of
any easy way to do it with a formula. However, since you posted in the
developer newsgroup I assume you want to use VBA and getting that
information via VBA is very simple. For any given task the syntax would
be:
NumAss = ActiveProject.Tasks(x).Assignments.Count
where "x" is the task index
For a whole project the code would be (assuming every resource on the
Resource Sheet has at least one assignment - if not a loop could be set
up to examine the assignment count for each task and add up the total -
taking into account multiple assignments for any given resource):
NumRes = ActiveProject.Resources.Count
Hope this helps.
John
Project MVP
