Current task assignee | Community
Skip to main content
Level 5
June 2, 2022
Question

Current task assignee

  • June 2, 2022
  • 1 reply
  • 587 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

RandyRoberts
Community Advisor
Community Advisor
June 3, 2022

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