Last task code | Community
Skip to main content
J
JustinEn
New Participant
December 5, 2022
Solved

Last task code

  • December 5, 2022
  • 2 replies
  • 956 views

Does anybody have the code to generate a "previous task completed" column on a project report? Thanks in advance for the help!

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

    Previous, meaning a predecessor? If so, I've used this text mode from @imgrund many times on a task report (thank you, Anthony!). It's from the Lateness of a Predecessor Task thread

    displayname=Predecessor Name and Actual Completion Date
    listdelimiter=
    listmethod=nested(predecessors).lists
    textmode=true
    type=iterate
    valueexpression=CONCAT({predecessor}.{name}," - ",{predecessor}.{actualCompletionDate})
    valueformat=HTML

    2 replies

    S
    Sheri_WhittenAccepted solution
    New Participant
    December 13, 2022

    Previous, meaning a predecessor? If so, I've used this text mode from @imgrund many times on a task report (thank you, Anthony!). It's from the Lateness of a Predecessor Task thread

    displayname=Predecessor Name and Actual Completion Date
    listdelimiter=
    listmethod=nested(predecessors).lists
    textmode=true
    type=iterate
    valueexpression=CONCAT({predecessor}.{name}," - ",{predecessor}.{actualCompletionDate})
    valueformat=HTML

      J
      JustinEnAuthor
      New Participant
      December 13, 2022

      thank you - I think this is what I'm needing! 

      N
      nerdyjess
      New Participant
      December 5, 2022

      Tasks that have Planned Hours > 0 with a Planned Start Date prior to Jan 1, 2022 and a Planned Completion Date after Dec 31, 2022
      Tasks that have Actual Revenue > 0 with a Planned Start Date prior to Jan 1, 2022 and a Planned Completion Date after Dec 31, 2022
      Hours that have an Entry Date between Jan 1, 2021 and Dec 31, 2022

      This may help it would have to be a date of tasks to pull previous functions in your report. I would pick the dates you're looking to break down, then, from there, decide what tasks you want to see. In a custom field of Previous Tasks Completed with their name or Queuetopic ID. Depends on how you want to pull. I hope this helps.

        Terms & ConditionsAccessibility statement

        Loading footer...