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. | Community
Skip to main content
R
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.

  • August 10, 2021
  • 1 reply
  • 738 views
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.
    Best answer by William--

    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

    1 reply

    William--
    Community Advisor
    William--Community AdvisorAccepted solution
    Community Advisor
    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
    R
    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.
    Terms & ConditionsAccessibility statement

    Loading footer...