Creating a report that shows a specific folder name with no documents

[TimothyBr]

Hi community! 

Are there any suggestions to pull a report on all projects that have a specific folder (i.e. Final Deliverables) which is empty. 

I am trying to see all projects that are closed where someone didnt upload final documents.

Thanks! 

[RandyRoberts · Accepted solution]

Project Report Filter - 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

More than one folder

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

 TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas