I need to have a time sheet summary report for a group of employees. I can show their single entry task hours and planned hours, but not summarized by the various hour entries - task hours, PTO, overhead hours, etc. in total for the time period.
Also, the planned hours are not for the report duration (e.g. one week) but are rather for the entire task duration - so it shows up as individual task line items with the TOTAL planned hours on every single line. (if the person has multiple entries for the same task over the course of a week, it will show the same total every single time so that it looks like they were planned to work way higher hours in the week instead of 40). -- Bob - 2 hours - planned 20 hours; then next line Bob - 1.5 hours planned 20 hours (in the end, it looks like Bob worked 40 hours but was planned to work double or triple that amount due to the double counting)
Ideally I want the report to say
Name -- total hours entered ---- total hours planned ---- total Task Hours --- total Admin Hours --- total PTO Hours
Does this not exist in WF? I cannot find it on any of the reports - and each of our efforts at building one has failed.
Thanks!!
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi @haleyammon,
Thank you for your question! The report you're describing does not exist as an out-of-the-box solution in Workfront, but you may be able to create something close. The challenges you're describing are due to the fact that Workfront's planned hours are tied to task objects.
The closest approach would be to build a time report that aggregates hours and groups them as needed.
Alternatively, you could use a dashboard and include separate reports for task hours, admin hours, and PTO hours. Although this wouldn't show the info in 1 report, it would show everything under the same dashboard.
- Monica
Views
Replies
Total Likes
Hi @haleyammon,
Thank you for your question! The report you're describing does not exist as an out-of-the-box solution in Workfront, but you may be able to create something close. The challenges you're describing are due to the fact that Workfront's planned hours are tied to task objects.
The closest approach would be to build a time report that aggregates hours and groups them as needed.
Alternatively, you could use a dashboard and include separate reports for task hours, admin hours, and PTO hours. Although this wouldn't show the info in 1 report, it would show everything under the same dashboard.
- Monica
Views
Replies
Total Likes
Views
Likes
Replies