Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Current task assignee

Avatar

Level 5

Hi there! We have a column within one of our reports that displays the "Current Task" that is active within each project using the text mode below. Is it possible to also include the assignee name(s) of the current task(s)? Any help is appreciated 🙂 Thank you!

displayname=Current Task

listdelimiter=

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," - ",{plannedCompletionDate}))))

valueformat=HTML

Topics

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

1 Reply

Avatar

Community Advisor

Here's a sample of one that I use. You can pull the parts you need:

displayname=Active Task & Due Date

listdelimiter=<div>

listmethod=nested(tasks).lists

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.leftmethod=ID

styledef.case.0.comparison.lefttext=ID

styledef.case.0.comparison.operator=notblank

styledef.case.0.comparison.operatortype=string

styledef.case.0.comparison.righttext=

styledef.case.0.comparison.trueproperty.0.name=bgcolor

styledef.case.0.comparison.trueproperty.0.value=F5FCF7

styledef.case.0.comparison.truetext=

textmode=true

type=iterate

valueexpression=IF({numberOfChildren}=0,IF({canStart},IF({status}="CPL","",CONCAT({name}," | ",{assignedTo}.{name}," ",{plannedCompletionDate}))))

valueformat=HTML

width=200