Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Project report that returns projects that have only the last task as active, and the remaining tasks completed?

Avatar

Level 2

Is there a way to build a project report that returns projects that have only the last task as active, and the remaining tasks completed?

5 Replies

Avatar

Level 5

Assuming that your workflow is structured so that the last task can only begin once the other tasks are complete, you could try something like this:

last task report filter.png

For that task number=total task count filter, you can add this in text mode (you should be able to switch back to standard mode afterwards, unless you've got any other filter statements that can only be built in text mode):

taskNumber=FIELD:project:totalTaskCount
taskNumber_Mod=eq

Avatar

Level 2

Thanks for the tip! We are able to build the following filter for a project report based on that:

tasks:canStart=true
tasks:canStart_Mod=eq
tasks:status=CPL
tasks:status_Mod=notin
tasks:taskNumber=FIELD:totalTaskCount
tasks:taskNumber_Mod=eq

 

Avatar

Level 5

Sorry--I skipped over that you were wanting a project report.

Avatar

Level 4

You can do this with Exists statements, but the best first step is to do this as a task report as that will help you figure out what your key details are that correctly isolate these projects.

 

Is there a reason this needs to become a project report? You can easily list project information on a task report. 

 

Once you have a functional task filter and a good reason to keep this at the project level, convert your filter to a text mode and copy it here or send it to me personally and I can show you how to make it into a project level exists.