Expand my Community achievements bar.

Wondering how Workfront Proof works? Join our AMA on May 8th and ask our Community experts!
SOLVED

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

Avatar

Level 4

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! 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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

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?