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

Project report, listing ready to start tasks with assignee(s)

Avatar

Level 10

I have a project report that lists tasks that are "can start" with an "{assignedTo}.{name}". The assignedTo is only working if a single person is assigned, no roles, no teams.

Usually we have a role pre-assigned in the template and the resource manager just adds a user or team and leaves the role there. Having more than one entry in the assignee field is breaking the assignedTo.

Is there another parameter I can use that will at least list the first entry?

I know a list of assignees in a list of tasks in a project report is a lot to ask 🙂

Here's my current code:

displayname=Current Task

listdelimiter=<div>

listmethod=nested(tasks).lists

textmode=true

type=iterate

usewidths=true

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

valueformat=HTML

width=200

Topics

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

1 Reply

Avatar

Level 7

Hi Randy,

You can create another column that shows the Job Role so resource managers can see one or the other set of details for the task.

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

Not an ideal solution but OR statements don't work with collections.

Hope this helps,

Teale