Total number of days a resource has been allocated
I’m working on a project with multi resources. Is it possible to run a report that shows the total number of days a resource has been allocated? So, I can calculate the work effort against a resources? Thank you
Answers
-
Are you looking to build an actual report, or are you wanting to show it as a line item on a sheet?
-
Ideally, I would like both options. I have a comprehensive plan where multiple resources are allocated to single tasks, so reporting on the actually work effort would be helpful.
-
Are you using multiple sheets or do you just have a single sheet for the entire project?
-
Currently I'm using a single sheet for the project
-
To run the report, you could simply create a new report, and set the criteria to show only rows for that particular resource. To display it on the same sheet, you could use a SUMIFS along the lines of
=SUMIFS([Column housing days]:[Column housing days], [Resource Column Name]:[Resource Column Name], "Resource of your choosing")
-
Thank you for your feedback, much appreciated!
-
Happy to help. Were you able to figure out a solution that worked for you?
-
Hi @Paul Newcome, any ideas on how to make this work when you have a resource working on multiple activities in parallel? How do I have it sum duration over unique date blocks and not overcount days/months that the resource is working on the project?
=ROUND((SUMIFS({Duration}, {Assigned To}, Name29) / 260) * 12, 1)
