Complex Workfront Report | Community
Skip to main content
L
LuteciaLo
Level 2
February 3, 2026
Question

Complex Workfront Report

  • February 3, 2026
  • 1 reply
  • 22 views

I need to create a report that shows jobs that have ALL tasks closed for that Team ID, in a specific time frame (last month).

Meaning I want to see the number of jobs that my team completed all tasks assigned to them. I don’t care if other team members are still working on their tasks and the job is still open - my concert is only with my team. I don’t need to see jobs that still have tasks less than 100% completed by my team. 

Sorry, I’m being redundant but every time I explain it to someone, they have a hard time understanding what I need. 

Can anyone help me? I was able to get a report of tasks completed by my team, but there might other tasks on these jobs that were not completed, so these jobs should not appear on my report.

Thank you.

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
February 4, 2026

are “jobs” equivalent to workfront projects? or parent tasks? or…?

I’m not sure why you’re using that word and this might be why people have a hard time understanding you (it’s always better if you use default workfront terminology rather than a new term your particular company may have customized).

And are the tasks assigned to the teamID or to a user who is on that team?

L
LuteciaLoAuthor
Level 2
February 4, 2026

Yes and yes. :) By jobs I mean WF Projects and TeamID. I have 4 people in the TeamID, so 4 users. I tried both ways, using the TeamID and manually adding all 4 users. I don’t think that’s the issue. I am able to create a report with all the tasks that are closed, with that TeamID, but there may be other tasks that are still in progress, so that Project shouldn’t be in the report. Only Projects with all tasks at 100% completed by that Team should show. 

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
February 4, 2026

​@LuteciaLo -- so, you would get a lot more progress made if you worded it using the exact Workfront terminology. I hope you don’t mind me setting these guardrails, as I truly believe that one of the ways you can most successfully create a report is by saying exactly what you intend to create. Using your original post as an example:

 

  1. “I want to see the number of jobs” -- to me this means, “I want make a project report”
    • When you go to create your report, you should probably have some extra restrictions here, such as “cancelled projects shouldn’t be counted” or “projects over a year old shouldn’t be counted” -- but this is entirely up to you. These kinds of restrictions can usually be done in Standard mode, e.g. Project Status not equal to Cancelled, Project Entry Date greater than $$TODAY-1y.
  2. In each project on my report, ALL tasks assigned to Team X should be complete (i.e. no task assigned to my team is incomplete)
    • Depending on what you did when you manually added users, you may have to create two filters. i.e. if you took the team off when you added users, then that’s something you would need to create an extra filter to compensate for.
    • You also might want some thinking around here where cancelled tasks are concerned. For now I would probably think you would exclude them from the filter.
  3. The Actual Completion date is “last month” -- this also requires a stringent definition. Do you mean in the past month (past 30 days, in other words)? Or do you mean last month (like if we’re in mid February, do you only want to see January dates and no february dates?)? 

 

Anyway, hopefully you see why we have to be clear when asking questions. I’m already halfway to giving you a project report, so I’ll just keep going but you can obviously see that if you didn’t mean to say that, we community members would spend a lot of time giving you answers that don’t work! So here we go:

  • Create a project report, and set it up with whatever project restrictions you want, in standard mode. (project status not cancelled, or project entry date in the past year, for example) Switch it to textmode.
  • Here’s some sample textmode for you. You would of course spot check the results to see if the filters are working.

EXISTS:a:$$OBJCODE=ASSGN
EXISTS:a:projectID=FIELD:ID
EXISTS:a:task:percentComplete=100
EXISTS:a:teamID=<your team ID goes here>
EXISTS:a:task:actualCompletionDate=$$TODAYb-1m
EXISTS:a:task:actualCompletionDate_Mod=between
EXISTS:a:task:actualCompletionDate_Range=$$TODAYe-1m


EXISTS:b:$$OBJCODE=ASSGN
EXISTS:b:projectID=FIELD:ID
EXISTS:b:task:percentComplete=100
EXISTS:b:task:percentComplete_Mod=lt
EXISTS:b:teamID=<your team ID goes here> 
EXISTS:b:$$EXISTSMOD=NOTEXISTS


What does the above gibberish mean? There are two filters acting in unison:

  1. Everything prepended with EXISTS:a: 
    • There’s at least ONE task in here that is assigned to my teamID and this task was completed “last month” (in January)
  2. Everything prepended with EXISTS:b:
    • There are NO tasks in here that are assigned to my teamID where the task percent complete is less than 100%

How did I get this gibberish (this textmode did not just spring from my head -- I cheated):

  1. I separately created an assignment report and made a filter in there to get exactly the assignments I wanted. All of this was done in standard mode. It was a good place to test out my suppositions, like “how do I filter for the team ID”. If you decided you want “Past month” instead of “Last month” and you weren’t sure how to do the text mode, this is where you would experiment. Same with if you decide you want a filter for your user names rather than the teamID.
  2. Once I get one set of filters working in the assignment report, I change it to text mode and bring it over to the project report.
  3. I prepend all the lines with “EXISTS:a:” (or b if it’s the second filter)
  4. I add the OBJCODE line and the linking line (the first two lines in each)
  5. If it’s a “NOTEXISTS” filter, I add a NOTEXISTS line.

 

I just gave a webinar on this last year so this information is stored on the recording here:

https://experienceleague.adobe.com/en/docs/events/workfront-recordings/workshop-rewind/workflow/master-exists-statements

Terms & ConditionsAccessibility statement

Loading footer...