I need to build a report that shows all of the tasks that my team is working on for the next two weeks. It doesn't matter if a task has a due date within the two week view or beyond the two week view. Which filters will allow me to do this? | Community
Skip to main content
C
CortneyDe1
Level 2
July 20, 2020
Question

I need to build a report that shows all of the tasks that my team is working on for the next two weeks. It doesn't matter if a task has a due date within the two week view or beyond the two week view. Which filters will allow me to do this?

  • July 20, 2020
  • 1 reply
  • 730 views

If there is a Workfront feature that already does this, I can use that instead of building a report.

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

    1 reply

    Christina_Jarosz
    Christina_Jarosz
    Level 9
    July 21, 2020

    Hey Cortney! You can do this through a task report (or an assignment report, too). We use a task report and filter by "Task Assigned to ID" with $$USER.ID.You can use a similiar wildcard filter of $$USER.homeGroupID or $$USER.homeTEAMID.

    See the list of wildcard filters here: https://one.workfront.com/s/article/Wildcard-Filter-Variables-810113772

    C
    CortneyDe1Author
    Level 2
    July 21, 2020

    Thanks Christina! I have the user wildcard set up, but right now it's showing all tasks beyond two weeks. I don't know how to filter down those tasks so I only see what's being worked on between now and 2 weeks from now.

    Christina_Jarosz
    Christina_Jarosz
    Level 9
    July 21, 2020
    This is how ours is…..but we do it by User ID assignedToID=$$USER.ID assignedToID_Mod=in actualCompletionDate_Mod=isnull plannedCompletionDate=$$TODAYbw plannedCompletionDate_Mod=between plannedCompletionDate_Range=$$TODAYew+1 project:status=CUR project:status_Mod=in status=CPL status_Mod=notin OR:1:assignedToID=$$USER.ID OR:1:assignedToID_Mod=in OR:1:actualCompletionDate_Mod=isnull OR:1:plannedCompletionDate=$$TODAYbw OR:1:plannedCompletionDate_Mod=between OR:1:plannedCompletionDate_Range=$$TODAYew OR:1:personal=true OR:1:personal_Mod=eq OR:1:status=CPL OR:1:status_Mod=notin The first says Christina Jarosz, Marketing Project Coordinator P 215.648.7168 | C 215.435.9412
    Terms & ConditionsAccessibility statement

    Loading footer...