Report for all users with the assigned projects and tasks and who do not have anything assigned to them | Community
Skip to main content
NarendraBh1
NarendraBh1
Level 2
June 19, 2026
Solved

Report for all users with the assigned projects and tasks and who do not have anything assigned to them

  • June 19, 2026
  • 2 replies
  • 104 views

Hello - I need to create a report where I can show the no. of projects and tasks assigned to each user in the group.

Also need the list who have nothing assigned to them.

How should I go about that?

    Best answer by skyehansen

    Addressing your second question since your first appears to be solved. Create 2 reports:

     

    1. An assignment report to be used to test your solution report
    2. Your solution, which is a user report.

    In the user report filter, put in the following in text mode.

    EXISTS:A:$$EXISTSMOD=NOTEXISTS
    EXISTS:A:$$OBJCODE=ASSGN
    EXISTS:A:assignedToID=FIELD:ID

     

    If a name shows up, you can test it in your assignment report. E.g. the name of John Smith is listed, so in your assignment report, filter on Assigned To ID = John Smith, and the result should be no assignments, thereby proving your user filter (nothing assigned) works.

     

    If I can make a suggestion - this is probably an incomplete question on your part so maybe think over what you really need and restate the question. The filter I provided pulls in everyone with exactly zero assignments and it’s usually better to pull in people with zero task assignments or zero issue assignments, or people with zero assignments on active projects, or people with zero assignments on tasks that are incomplete -- these are just examples that I’m listing -- not a comprehensive list.

    2 replies

    Lyndsy-Denk
    Community Advisor
    Lyndsy-DenkCommunity Advisor
    Community Advisor
    June 19, 2026

    Instead of reports, consider looking into Workload Balancer. You will need to apply filters to narrow down the users, but this tool is ideal for showing assignments (both tasks and issues). Users who have no assignments will also appear, but their row will have nothing to expand to.

    Otherwise, you can try to build reports, but they might not give you all the answers you’re looking for as reporting can’t look at both tasks and issues together. If you want to take that approach, look at the Assignment report type.

    NarendraBh1
    NarendraBh1Author
    Level 2
    June 19, 2026

    Thanks - I tried it already but it gives the hours.
    My stakeholder wants to see the no. of assigned Project and Tasks

    ninoskuflic
    ninoskuflic
    Level 5
    June 20, 2026

    You can create for example an assignment report where you can show tasks and projects assigned to a user and include a graph. Something like this:

     

     

    P.S. I would recommend going with tasks instead of projects - otherwise it can show duplicated data - e.g. a user being assigned both to a project and task, while the only work happening should be on a task - unless the person is a PM.

    If this solved your issue, please mark it as solved so others can find the solution faster.
    skyehansen
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe ChampionAccepted solution
    June 23, 2026

    Addressing your second question since your first appears to be solved. Create 2 reports:

     

    1. An assignment report to be used to test your solution report
    2. Your solution, which is a user report.

    In the user report filter, put in the following in text mode.

    EXISTS:A:$$EXISTSMOD=NOTEXISTS
    EXISTS:A:$$OBJCODE=ASSGN
    EXISTS:A:assignedToID=FIELD:ID

     

    If a name shows up, you can test it in your assignment report. E.g. the name of John Smith is listed, so in your assignment report, filter on Assigned To ID = John Smith, and the result should be no assignments, thereby proving your user filter (nothing assigned) works.

     

    If I can make a suggestion - this is probably an incomplete question on your part so maybe think over what you really need and restate the question. The filter I provided pulls in everyone with exactly zero assignments and it’s usually better to pull in people with zero task assignments or zero issue assignments, or people with zero assignments on active projects, or people with zero assignments on tasks that are incomplete -- these are just examples that I’m listing -- not a comprehensive list.

      NarendraBh1
      NarendraBh1Author
      Level 2
      June 23, 2026

      I agree - It can be incomplete.
      So, I am trying to create a report of active users who are do not have any active* task or project assigned to them.

      *The task or project should not be in a cancelled, rejected or complete state

      skyehansen
      Community Advisor and Adobe Champion
      skyehansenCommunity Advisor and Adobe Champion
      June 23, 2026

      I’ve given you the first part of your statement above. I’d like to see you add the additional lines (task/project not cancelled, rejected or complete). This type of filter is really easy which is why I would love to see you give it a try. It should be set up in your assignment report using standard mode for “task not cancelled, project not cancelled, and so on”. When you get the filter working in your assignment report, switch it over to text mode and copy and paste the parts about the task and project into your USER report under the code I just gave you, and preface each of the lines with the same “EXISTS:A: ” prefix.

       

      Would you like to try?

      Terms & ConditionsAccessibility statement

      Loading footer...