Expand my Community achievements bar.

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
Community Advisor

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
Community Advisor

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

This appears to do the trick. Thanks so much @Doug Den Hoed‚ !