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!
Solved! Go to Solution.
Views
Replies
Total Likes
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
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?
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies