Total number of days a resource has been allocated

Stevefc

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             

 

Paul Newcome

Are you looking to build an actual report, or are you wanting to show it as a line item on a sheet?

Stevefc

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.   

Paul Newcome

Are you using multiple sheets or do you just have a single sheet for the entire project?

Stevefc

Currently I'm using a single sheet for the project 

Paul Newcome

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")

Stevefc

Thank you for your feedback, much appreciated!

Paul Newcome

Happy to help. Were you able to figure out a solution that worked for you?

breso

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)