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

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