Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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
Level 9
Level 9

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

View solution in original post

4 Replies

Avatar

Correct answer by
Level 9
Level 9

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

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 9

Hi @William English‚

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

Best regards,

Kundan.

Avatar

Level 9
Level 9

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