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!