Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
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.

Avatar

Level 3
 
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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 solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

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

Avatar

Level 3
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.

Avatar

Level 10

Hi @William English‚

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

Best regards,

Kundan.

Avatar

Community Advisor

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

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