Total hours by role in templates

[J_Mas]

I'm trying to get at total planned hours for each of the roles within my workflow templates. There doesn't seem to be a way to see this within the template itself, so I'm guessing I need to build a report?

I've tried building a Template Tasks report but can't seem to get at the information I need. Part of my issue is that for most of my tasks where multiple roles are assigned (e.g. Writer and Designer), the Planned Hours are not split 50/50. It might be more like 85% Writer and 15% Designer (these hour ratios are all set within the Assignments section of a task within the template).

I feel like I need the equivalent of an assignment-level report but at the template level, so I can get at something like "assignment >> workrequired" for the role instead of the task.

Can anyone point me in the right direction?

[RandyRoberts]

You can do this easily in Projects but templates is a bit more challenging. I created an assignment report that groups by role, added to a dashboard and then put that dashboard on the "template" layout. You do need to put a prompt for the template name or you'll get every template you have.

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas

[J_Mas]

That sounds like a great solution @RandyRoberts! Could you give me a little more insight as to the actual name of the field you're using for the prompt? I tried "Project >> Template ID" but I don't think that's correct.

I created an Assignment level report based on your screenshot, and added it to a dashboard and then to my Templates layout template. However when I load the report within a template, it seems like the tasks it's listing (under the grouped job roles) are all tasks that have ever used this template, as opposed to just the current template tasks themselves.

[RandyRoberts]

Yea, without the prompt you get a lot of irrelevant tasks. I use Template>>Name for the prompt and just copy the name of the template I'm on at the moment.

On a side note, I added a field called "template task count" to the project form as well as a "Template Validated By" field. With these I can see who made and/or checked the template as well as compare project tasks to template tasks to see if users added or deleted tasks from the template when a project was created.

[J_Mas]

Hmm....and it's definitely an Assignment report? I don't have "Template Name" as a choice in either my report columns or in the report prompt menu. Did you have to use Text Mode to get it?

Assignee report column choicesAssignee report prompt choices

[RandyRoberts · Accepted solution]

Oops, it's a template task report. Sorry 'bout that.

[J_Mas]

Woo-hoo! That worked! Thank you so much!

[RandyRoberts]

You're welcome, glad I could help.

[J_Mas]

Hey @RandyRoberts, thanks again for your initial help on this issue. However I've recently realized that this didn't actually solve my problem. The Planned Hours field that gets pulled into the report is the Planned Hours of the task and not the Assignee.

So if the task has 4 hours and the hours are split 85% for a Designer and 15% for an Art Director, I would like to see 3.4 hours listed for the Designer and 0.6 hours listed for the Art Director. Unfortunately the report just shows 4 hours for the task and no split.

I can see the split if I edit the task within the template, but I can't seem to find out how to get this field to show up on a report.

Template Task Report:

Template:

Edit Template Task: