How do I create a task report that displays the hours for multiple people assigned to the same task? | Community
Skip to main content
R
RickBo1
Level 2
June 24, 2021
Question

How do I create a task report that displays the hours for multiple people assigned to the same task?

  • June 24, 2021
  • 3 replies
  • 695 views

I want to create a task report that shoes the hours for each individual assigned to the same task. In my efforts to create this report, all of the hours are showing up under one person when the task actually includes 3 - 4 more individuals.

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

3 replies

imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
June 24, 2021

I have this column added to one of my views to see hours by Assignee

displayname=Assignment Breakdown

listdelimiter=<br>

listmethod=nested(assignments).lists

textmode=true

type=iterate

valueexpression=CONCAT({assignedTo}.{name}," (",{role}.{name},") - ",{workRequired}/60,IF({workRequired}/60>ABS(1)," Hours"," Hour"))

valueformat=HTML

Hope that helps

    Kundanism
    Kundanism
    Level 10
    February 21, 2022

    Hi @Anthony Imgrund‚

    Thanks and I remember you helped the above code to make our lives easier.

    As suggested, we started to use assignment breakdown as column in project view, the code is;

    displayname=Assignment Breakdown

    listdelimiter=<br>

    listmethod=nested(assignments).lists

    textmode=true

    type=iterate

    valueexpression=CONCAT({assignedTo}.{name}," (",{role}.{name},") - ",{workRequired}/60,IF({workRequired}/60>ABS(1)," Hours"," Hour"))

    valueformat=HTML

    Id planned hours is 40 hrs equally between 3 assigments, then the planned hour shows 13.3333333 hrs each.

    Any solution to round this number?????

    Thanks in advance.

    Mvh

    Kundan

    R
    RickBo1Author
    Level 2
    June 24, 2021

    Huge help. Thanks so much Anthony!

    -Rick

    R
    RickBo1Author
    Level 2
    July 6, 2021

    This is great in creating a column of planned hours by assignee. How might I also create a column of actual hours for these assignees?

    Terms & ConditionsAccessibility statement

    Loading footer...