Expand my Community achievements bar.

SOLVED

Show task assignee name as a column on a Project report

Avatar

Level 2

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 7

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

9 Replies

Avatar

Level 7

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 7

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

Community Advisor

 

Oooh! Very nice, @RhondaGTriggs!

 

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 2

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

Avatar

Level 2

Hi Rhonda,

  Is there a way to organize the tasks in sequential order? I have been trying to figure it out and had no luck?

 

Thank you for your help.

 

-Michelle 

Avatar

Level 7

I apologize for my late response... unfortunately, there are limitations to collections / nested lists:

Limitations of a collection View

Consider the following limitations when you are building a collection view:

  • You cannot control the order in which collection data is displayed.
  • You cannot apply conditional formatting to a collection view.
  • You cannot make an object in a collection a clickable link.
  • You cannot build a collection view of another collection (a list with other lists in it)

Avatar

Level 3

I know this was posted quite a long time ago - but am wondering if you could share the text mode for your "Last Update" column?! This looks like it would be SO helpful for us. Thank you in advance

Avatar

Level 1

@RhondaGTriggs Hello, resurfacing this thread as I'm deep in creating reports and agree that this would be helpful.