Document Count column in Project Report

[SarahSt6]

I have created a project report that lists all projects done by our marketing teams the past two quarters. However I have also been asked to include a column that shows how many documents are in each project. I am having trouble figuring out what text mode to input as I'm also not finding a pre-made column that can help. Does anyone have any ideas on how to get this column created?

[Rafal_Bainie · Accepted solution]

hi,

sadly, my best guess is that you won't be able to do that. Workfront offers total task and total issue count for projects, but I haven't notice doc count.

Maybe someone will prove me wrong.

Best

Rafal

[Doug_Den_Hoed__AtAppStore]

Hi @SarahSt6,

I concur with @SarahSt6, but if you need the document count per project badly enough, you might consider:

• creating a document report grouped by project name, collapsed, with the number of docs then showing parenthetically in the grouping, assuming there is at least one document per project (poor), or
• adding a column to your existing project that iterates the document collection but with listdelimiter=& z w j ; (with no spaces, keeping the results on a single line) and valueexpression="|" (vs a valuefield) to effectively draw a bar using "|" (notches) in order to see the relative number (since collections cannot be counted, natively, As Designed)

Regards,

Doug