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

SOLVED

How to filter for "Min" task number?

Avatar

Level 2

Looking for syntax (presumably in text mode) to add a filter to a task report to only display the minimum open task number for a project.

Example:

A Project has 5 tasks:

Task 1 - Complete

Task 2 - Complete

Task 3 - Open

Task 4 - Open

Task 5 - Open

I want to return only Task 3 (the lowest open task). In SQL, I would use the MIN() function to do this. Is there something similar using Workfront's text mode syntax?

Thanks!

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Keegan,

Assuming these tasks are chained (e.g. Finish-to-Start), you could check for Percent Complete < 100 and Handoff Date Not Blank to then retrieve only Task 3.

Regards,

Doug

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Hi Keegan,

Assuming these tasks are chained (e.g. Finish-to-Start), you could check for Percent Complete < 100 and Handoff Date Not Blank to then retrieve only Task 3.

Regards,

Doug