Project Report to Pull Project that has none of its Tasks Started yet

[Abka]

Hi,

I am trying to build a workfront report that Pulls in List of Projects that are in Planning Status and None of the underlying Task is started yet, i.e all Tasks on such Project should be in New Status.

Appreciate the help

[-JC · Accepted solution]

Hi @Abka, you would leverage an Exists statement to accomplish this by essentially saying "show me all projects, with a status of Planning, where no tasks exist that are in a status other than New". 

So, in a Project report, you would add the following text mode code to the filter:

status=PLN
status_Mod=in

EXISTS:A:$$EXISTSMOD=NOTEXISTS
EXISTS:A:$$OBJCODE=TASK
EXISTS:A:projectID=FIELD:ID
EXISTS:A:status=NEW
EXISTS:A:status_Mod=notin

More info here: https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/create-comple...

[Abka]

Thanks a lot :-). That worked

[kautuk_sahni]

@Abka  we noticed your question and invite you to our [Workfront AMA] Ask Me Anything about Workfront System Smarts & Strategic Starts on Wed, Oct 29, 2025 | 9–10 AM PDT. Experts will answer questions on topics like: day-to-day system tasks, strategic planning, Reporting, Adoption, System Maintenance, Notifications, Governance, Roadmapping, and Custom Forms. Post your questions in advance to ensure they’re answered. Reminder: All AMAs are TEXT-ONLY—no video or recording. RSVP & submit questions in advance here: https://adobe.ly/46xKfHM