Hi, Has anyone figured out how to create a program level report that summarizes status, overall percent complete, final planned completion, etc? Much like the stat's that are seen on the program page but are not visible as fields for reporting? AND does anyone know how to create a calculated fiel...

Thanks for the reply. Sounds like I will have to go with the matrix hours report plus a project report. Mollie

Hi Monique, Did you ever figure out a solution for this? I'm looking for something similar but hours filtered by job role or team or group. Thanks! Mollie

Does anyone have any magic to create a bar graph that would show average hours per project by job role?

Hi Csengi, That's the thing about collections; they can't be individual lines. It's a one to many relationship between programs and projects. I don't know of any other way to show it. -Mollie Mollie Shatek, PMP M +1 303 204 3000 **Click HERE<> to enter a Workfront Help/ Change/ New or Modified ...

Hi, To do that you would need to use text mode for a collection in your program report something like:displayname=Projects in the Programlistdelimiter=<p>listmethod=nested(projects).liststextmode=truetype=iteratevaluefield=namevalueformat=HTML Hope that helps. Mollie

Hi, If you do a Program type report and add the Portfolio Name via text mode (Portfolio ID is only available without text mode) you can edit the program name inline. displayname=linkedname=directnamekey=portfolio:namequerysort=portfolio:nametextmode=truevaluefield=portfolio:namevalueformat=HTML -Mo...

Hi all, Thanks for the replies! Bummer there is not a solution for now. New Workfront reporting CAN NOT get here soon enough! @Matt Thomas‚

I am using a prompted report that filters for a multi select dropdown on a user custom form. I would like to add some sort of indicator of which prompt was selected. I realize if you are on a report view you can do a "Show Prompts" but in my case this report is part of a dashboard and I would like...

Hi, Thanks for the response. I had gotten that far though :-) I want to make the formatting conditional on the status of the project. If project status is Current AND the program level custom field is blank, then highlight the cell red. Right now my condition is If blank highlight red.