Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

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

Level 10

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