How to filter for "Min" task number?

Question

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 Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO