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

Show task assignee name as a column on a Project report

Avatar

Level 1

Hello All,

I am hoping someone can help with my query.
I have a project level report that I want to show who is assigned to the current task.
I have managed to show the name of the current task as a column but I am struggling to find the code to show who is assigned to that task.
I am hoping someone might have the code to show this?

Thank you in advance.

1 Accepted Solution

Avatar

Correct answer by
Level 4

I have a column that displays task due date, name of task, assignee for tasks due in the next 7 days:

TASKS=A WEEK AHEAD 
displayname=Upcoming Tasks
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({numberOfChildren}=0,IF({plannedCompletionDate}>$$TODAY+1d && {plannedCompletionDate}<$$TODAY+1w,IF(ISBLANK({actualCompletionDate}),CONCAT({plannedCompletionDate},": (",{name}," | ", {assignedTo},")"))))
valueformat=HTML
width=300

I hope this helps! 2022-09-06_10-53-18.jpg

View solution in original post

4 Replies

Avatar

Level 4

This feels like a job for collections (https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/reference-collec...)

 

I think the largest variation in the code is going to be how you're determining what the "current task" is/are.

I'll note that I've found collections to be helpful, but that they also impact performance.

 

If the current task logic is involved, it feels closer to what we're using Fusion for where it needs to find a very specific task on a project and then write the field value to a field on the project object.  We have jobs doing this for both assignments and planned/actual dates.

Avatar

Correct answer by
Level 4

I have a column that displays task due date, name of task, assignee for tasks due in the next 7 days:

TASKS=A WEEK AHEAD 
displayname=Upcoming Tasks
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({numberOfChildren}=0,IF({plannedCompletionDate}>$$TODAY+1d && {plannedCompletionDate}<$$TODAY+1w,IF(ISBLANK({actualCompletionDate}),CONCAT({plannedCompletionDate},": (",{name}," | ", {assignedTo},")"))))
valueformat=HTML
width=300

I hope this helps! 2022-09-06_10-53-18.jpg

Avatar

Level 10

 

Oooh! Very nice, @RhondaTriggs!

 

That (showing the Tasks and Owners planned to be completed within the next 7 days from within a Project report) is a very useful bit of textmode, and is similar to our Hot Sheet solution, which also sorts the items, includes those that are late (optionally, in red), and includes a link beside each for navigation, as per our video.

 

Regards,

Doug

Avatar

Level 1

This is great, I have managed to use this idea to combine name of task and assignee.
Thank you!