Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

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