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!
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
This appears to do the trick. Thanks so much @Doug Den Hoed‚ !
Views
Replies
Total Likes
Views
Likes
Replies
Views
Like
Replies