How to filter for "Min" task number? | Community
Skip to main content
K
KeeganWa
Level 2
November 30, 2021
Solved

How to filter for "Min" task number?

  • November 30, 2021
  • 1 reply
  • 645 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Doug_Den_Hoed_AtAppStore

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

1 reply

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
Community Advisor
November 30, 2021

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

K
KeeganWaAuthor
Level 2
December 1, 2021

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

Terms & ConditionsAccessibility statement

Loading footer...