Project report, listing ready to start tasks with assignee(s) | Community
Skip to main content
RandyRoberts
RandyRoberts
New Participant
Jan 4, 2021 5:18 PM UTC
Question

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

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

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

    1 reply

    TealeMcCleaf
    Level 6
    Jan 4, 2021 7:19 PM UTC

    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

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...