Show task assignee name as a column on a Project report

Question

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.

RhondaGayleTX · Accepted Answer

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 Taskslistdelimiter=

listmethod=nested(tasks).liststextmode=truetype=iteratevalueexpression=IF({numberOfChildren}=0,IF({plannedCompletionDate}>$$TODAY+1d && {plannedCompletionDate}<$$TODAY+1w,IF(ISBLANK({actualCompletionDate}),CONCAT({plannedCompletionDate},": (",{name}," | ", {assignedTo},")"))))valueformat=HTMLwidth=300I hope this helps!

Jason_JB · Answer

This feels like a job for collections (https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/reference-collections-report.html?lang=en)

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded