Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Project Report that is filtered by Task existing in certain status


Level 4

Hi WF Community - hoping for some help here.

I am looking for a way to create a report with project level information but i need it to filter based on a specific task within the project that is not in a complete status.

So all projects with task name X where the status of the task is New or In Progress.

Any thoughts? I have tried a few versions of report styles and seems that the project level fields that I need are contained in a custom form on the project - so need access to that but also this specific task that indicates we have not passed that point - or that we have passed that point.

Thanks in advance!



Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies


Level 4

Hi Sherri! You can use the following as a text-mode filter on your Project report. This allows you to filter the Project report based on the Task-level data. Then, just add all the usual Project fields on your view.



tasks:status=INP NEW



Level 10

Hi - so after you do all the project type filters you want on the report (i.e. project status = Current, or owner ID equals $$USER.ID, etc.), switch to text mode and then past this underneath



EXISTS:1:name={name you want here}




See if that works.