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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you for your feedback, much appreciated!
-
Happy to help. Were you able to figure out a solution that worked for you?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives