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.

[William-- · Accepted solution]

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

[rickb78751305]

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.

[Kundanism]

Hi @William English‚

This is great sharing, do you have any idea to add similar column for project view.

Best regards,

Kundan.

[William--]

Kundan, it's not possible to do for a project view.

This is a collections column. Assignments are a collection in tasks or issues, so you can have this column in a task or issue report. Assignments are not a collection in projects, so this view is not possible in a project report.

To understand when you can or can't do this, go to the API Explorer and look for the kind of object that matches your report (in this case, you would look at "Project" in the API Explorer because you are building a project report/view. Click on the "Collections" tab. Anything you see in that tab can be listed in a column in your report. If the thing you want to make a list of isn't in the collections tab, it's not possible.

Thanks,

-WE