Report to show completed projects with no document uploaded into a specific folder

Question

Hi, 
 
We are looking for a way to build a report that shows completed projects that has no document inside a specific folder. This is our current of folder settings inside document page of project:

Is there a way to build such a report? For example we will want to see the completed projects that have no documents uploaded into the 'Final Files' folder only. 
 
Your input on this is greatly appreciated. Thanks!

Doug_Den_Hoed__AtAppStore · Accepted Answer

Hi @arthurchalamet,

I invite you to try this Project report filter to meet your requirement to return only Completed Projects without at least one file in a Particular Folder.

EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=DOCFLD
EXISTS:a:document:projectID=FIELD:ID
EXISTS:a:folder:name=TYPE YOUR PARTICULAR FOLDER NAME HERE
EXISTS:a:folder:name_Mod=cicontains
status=CPL

Regards,

Doug

Madalyn_Destafney · Answer

This is a tough one. I think you'll want to go with a Document report but not sure it'll get as granular as you're looking for.

You could get at least a potential pool of projects that don't have docs in a finals folder but does have docs in general by filtering in 'has documents', 'complete' status and project completed in your given timeframe, example below:

From there I can't figure out how to specify anything about document folder names. Are your final files always a specific document/format type? If so, you could shrink the project's results by filtering out any docs in that specific file type like a PDF...
This isn't a full solution but should help you get going on something!

Sign up

Login with SSO

Login to the community

Login with SSO