So here's the complexity. Generally, reports give you one line per whatever type of report it is - so if it's a project report, it's one row per project. If it's a task report, it's one line per task. You want one line per project, so it should be a project report. But you want to access task info...

I think the trap is making sure 'Group Columns' is clicked - see attached Word document

Could I ask a couple of questions to clarify what you're trying to achieve: In the case where a project has multiple tasks that have an entry for 'Type', what is it you want displayed? Will there only be one in the current month, for example, and others can be ignored or will be possibly be severa...

So here's a thing. I first tried this a week ago and got 0's in the expense columns. Mucked around a bit, posted the forum. When I got your replies, I double-checked and was still getting 0's. When Lucas posted his reply, I went into Sandbox and checked we were recalculating projects ovrnight (which...

Thanks for the detailed response Doug. I hadn't thought of concatenating all the text fields to a group heading. Unfortunately, I think there's too many in this case but I'll just pop that in the bag of reporting tricks to pull out on a rainy day. Unfortunately 'Planned Expense Cost' and 'Actual E...

Thanks for the suggestion Doug, but that ONLY gives me the expense totals. The other columns (Project description, project owner, some custom fields) don't show on the summary or matrix as they are non-numeric. I have an existing report with about a dozen columns all sourced directly from the proj...

I'm sure I'm missing something but this is doing my head in. I have an existing report with filters that is listing mainly project details (Name, Owner, current end date, some custom flags). I want to include the total planned and actual expense amounts in this table. This isn't available (even in...

Thanks Eric. We have a report for team leaders that shows all their staff, and the status of their timesheet that week, and one for our PMO that lists all overdue timesheets for the week. The problem is, when we have a repeat offender I want the team leader to be able to sit down and say "Look a...

There's a few, but they are limited in functionality. Try looking here: https://support.workfront.com/hc/en-us/articles/218328617-Time-Off-PTO-Reports As has been suggested, you could have people book time to a leave project to allow reporting. However, it doesn't have priority over other projec...

Does anyone know a way to report on when staff have submitted their timesheets? We're switching from another system to Workfront as the source of truth for hours logged to projects. I'd like a team leader (timesheet approver) to have a report which shows the date and time of every timesheet submissi...