@skyehansen this was perfect, thank you so much!!!

Thanks for your response! Summary section, minus the count column, is the look my stakeholders want but it doesn't look that way when the report is emailed to them on a monthly basis since it reverts to the detailed section view.

Hi everyone! i am working on an Assignment report for a project team so they can see all the completed projects they were assigned to. This report is based on the $$User so it'll be a custom view for whomever opens the report. If a user was assigned to multiple tasks in a project it will show up mul...

ah, thank you!

didn't work, looks like the system keeps reverting back the value format to it's original form, "compound#M:D": displayname=Actual Duration (no days)linkedname=directnamekey=actualdurationquerysort=actualDurationMinutestextmode=truevaluefield=actualDurationMinutesvalueformat=compound#M:Dviewalias=ac...

Could someone share the text mode needed to display the Project Actual Duration without "Days" in the result? This will save us a step in excel so we don't need to delete all the "days" in this column.

Got it to work! the Owner filter I used was actually the owner of the document, not the project. One last question if you don't mind. I tried adding in the following text mode to filter to the Project level owner of the project itself, but i keep getting an error message. Any advice on how this coul...

Apologies for the late response! The filter I have has mostly project level filters (project actual completion date is this year, Project name does not contain 'test', project status is either complete or archived). I noticed the projects that have a mix of Word and PDF files in the final folder wil...

Thank you for the filter suggestion! I implemented it and my report finally brought in the results from the Final Folder. However, for projects that have more than 1 document in that folder the report was only showing the file that was most recently uploaded to the final folder. Any way to bypass th...

Hi everyone! The problem I am trying to solve is develop a report (I started with a document report) to identify the number of files in a specific folder in our Project Folders (the folder we are targeting is called "Final Files"). We are attempting this because we want to see the number of final fi...