Project report, listing ready to start tasks with assignee(s) | Adobe Higher Education
Skip to main content
RandyRoberts
Community Advisor
RandyRobertsCommunity Advisor
Community Advisor
January 4, 2021
Frage

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

  • January 4, 2021
  • 1 Antwort
  • 404 Ansichten

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

    Dieses Thema wurde für Antworten geschlossen.

    1 Antwort

    T
    TealeMcCleaf
    Level 6
    January 4, 2021

    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

    Allgemeine NutzungsbedingungenAccessibility statement

    Loading footer...