Show simple duration breakdown on a project view | Community
Skip to main content
K
KellyFo
Level 3
November 3, 2020
Question

Show simple duration breakdown on a project view

  • November 3, 2020
  • 3 replies
  • 605 views

Hey there hive! Does anyone know how to get the simple calculated time breakdown for assignments that is in a task to show on a project view? I would love to be able to look at all the tasks in a project and see how many hours were allotted to each person, without having to open the individual task and look at it in there. Any help would be appreciated. Thanks!

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

    3 replies

    T
    TealeMcCleaf
    Level 6
    November 3, 2020

    Hi Kelly -

    You can accomplish this with this textmode code:

    valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," - ",{role}.{name},"- ",{workRequired}/60,IF({workRequired}/60>ABS(1)," Hours"," Hour")))))

    listdelimiter=<p>

    listmethod=nested(tasks).lists

    valueformat=HTML

    displayname=Current Task / PCD

    textmode=true

    type=iterate

    The issue you'll run into is that you can't force the results to group by task name so you'll get the breakdown by job role but they may not appear in sequence in the results.

      Doug_Den_Hoed__AtAppStore
      Community Advisor
      Doug_Den_Hoed__AtAppStoreCommunity Advisor
      Community Advisor
      November 3, 2020

      Huh! Very interesting Teale,

      I'm surprised that enumerating Tasks in that fashion then breaks out multiple Roles per Task (e.g. a collection within a collection), and would have expected only one row per Task, with the Primary Role.

      Thanks for sharing!

      Regards,

      Doug

      T
      TealeMcCleaf
      Level 6
      November 3, 2020

      Welcome! I'm glad you like it 😀

      Terms & ConditionsAccessibility statement

      Loading footer...