Skip to main content
RickBo1
Level 2
August 10, 2021
Solved

In some of our projects, the same task is assigned to multiple users and we would like to run task reports that display the actual hours each individual spent on the task.

No text available
    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    William
    WilliamAccepted solution
    Adobe Employee
    August 11, 2021

    On a task report, add a text mode column:

    displayname=Actuals by User

    listdelimiter=<div>

    listmethod=nested(assignments).lists

    textmode=true

    type=iterate

    valueexpression=CONCAT({assignedTo}.{name}," - ",({actualWorkCompleted}/60)," Hours")

    valueformat=HTML

    If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
    View in thread

    4 replies

    William
    Adobe Employee
    WilliamAdobe EmployeeAccepted solution
    Adobe Employee
    August 11, 2021

    On a task report, add a text mode column:

    displayname=Actuals by User

    listdelimiter=<div>

    listmethod=nested(assignments).lists

    textmode=true

    type=iterate

    valueexpression=CONCAT({assignedTo}.{name}," - ",({actualWorkCompleted}/60)," Hours")

    valueformat=HTML

    Translate
    If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
    RickBo1Author
    Level 2
    August 11, 2021
    Perfect. Thanks William! Rick Booth Director of Creative Services NESN 480 Arsenal Way, Watertown, MA 02472 P: 617-927-1308 M: 617-861-7915 The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited.
    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...