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

Forum|Forum|1 year ago
February 22, 2024
3 replies
965 views

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?

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

KristenS_WF

Level 6

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:

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

Y

YinMe

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

KristenS_WF

Level 6

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

The_Real_Melinda_Layten

Level 3

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.

Y

YinMe

Level 2

Thanks for the tip!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded