How to filter for "Min" task number?

[KeeganWa]

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!

[Doug_Den_Hoed__AtAppStore · Accepted solution]

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

[KeeganWa]

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