Last task code

Question

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

Sheri_Whitten · Accepted Answer

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

nerdyjess · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO