Skip to main content
Level 2
Apr 1, 2025 9:02 PM UTC
Solved

Creating a report that shows tasks when a specific folder is empty (EXISTS statements)

I am creating a task report with the goal of showing tasks that are ready to start by a certain group of individiuals (these filters are already applied) and don't have documents within a specific folder (the project-level folder titled "design").... Is there a way to filter by that second part? If so, can you assist with the text mode?

In summary, I want the report to show me tasks in which the task is assigned to the a team or specificed individuals, it's predecessor is complete, AND there are no documents within the "design" folder.

 

There was a very similar question Community question by @timothybr and response by @randyroberts that is almost the answer, but I can't figure out how to tweak it for me need. (https://experienceleaguecommunities.adobe.com/t5/workfront-questions/creating-a-report-that-shows-a-specific-folder-name-with-no/m-p/617520#M55996)

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
skyehansen
skyehansenAccepted solution
Apr 1, 2025 11:48 PM UTC

I'm not certain this will work for what you need, but one thing you could try is to change the linking lines (lines ending in "document:projectID=FIELD:ID"). Trade all the FIELD:ID parts for FIELD:projectID and see if that gets you anywhere.

1 reply

skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community AdvisorAccepted solution
Apr 1, 2025 11:48 PM UTC

I'm not certain this will work for what you need, but one thing you could try is to change the linking lines (lines ending in "document:projectID=FIELD:ID"). Trade all the FIELD:ID parts for FIELD:projectID and see if that gets you anywhere.

Translate