Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Last task code

Avatar

Level 3

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

3 Replies

Avatar

Level 2

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.

Avatar

Level 6

Previous, meaning a predecessor? If so, I've used this text mode from @AnthonyIm 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