Creating a report that shows a specific folder name with no documents | Community
Skip to main content
TimothyBr
TimothyBr
Level 4
September 6, 2023
Solved

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

  • September 6, 2023
  • 1 reply
  • 727 views

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! 

Best answer by RandyRoberts

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

1 reply

RandyRoberts
Community Advisor
RandyRobertsCommunity AdvisorAccepted solution
Community Advisor
September 6, 2023

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

    N
    Natalie_Shanks_OneAmerica
    Level 2
    April 1, 2025

    This is great! I have a similar need, but can't figure out how to tweak it for my use case. 

     

    I need to show tasks are ready to start but have a specified project-level folder empty. Basically the same as above, just need to pull it from a task level, because the other criteria I need to filter by is aligned to the task. I believe this is possible, just can't figure it out. Does this seem possible? Can anyone help?

     

     

    Terms & ConditionsAccessibility statement

    Loading footer...