I would like to add a "current task" column to an active project report - any ideas? | Community
Skip to main content
JeremyNe
JeremyNe
Level 2
March 10, 2021
Question

I would like to add a "current task" column to an active project report - any ideas?

  • March 10, 2021
  • 1 reply
  • 515 views

I would like to add a column to an active project report (any project in the "current" state) that shows what task is happening NOW... or what is the next task that needs to be completed.

I would imaging that there's some text mode trickery that needs to happen, any suggestions would be appreciated! Thanks to all!

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

    1 reply

    R
    Community Advisor
    Richard_Le_Community Advisor
    Community Advisor
    March 10, 2021

    Hi Jeremy,

    With credit to WF-Pro.com . . . . there's some example text mode code on here that should achieve exactly what you are looking for.

    The below code will return the name and planned completion date of all tasks that are currently being working on, or can start in a project

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

    listdelimiter=

    listmethod=nested(tasks).lists

    valueformat=HTML

    displayname=Current Task

    textmode=true

    type=iterate

    Best Regards,

    Rich.

      Terms & ConditionsAccessibility statement

      Loading footer...