Hi @dippaul,
An innocent enough question...but to my knowledge, answered only "partially", using native functionality:
- when a Task is updated, Workfront "echos" that Task's Last Update date "up" to the Project's Last Update Date
- on a native Project report (or view), it is possible to use textmode on a column to iterate all Tasks
- within that iteration, it is also possible to include or exclude certain items based upon a condition
- in your case, you could choose to show only the Task(s) whose Last Update Date matches the Project Last Update Date
- in the Happy Path case -- where one Task was just updated -- such a conditionally iterated column would show the one and only Task of interest
- In the Too Much Of A Good Thing case -- where several Tasks were all bulk updated (or created) at once -- such a column would show...all of them...eww...
- In the Where'd It Go case -- where some other "non-Task" change to the Project is made, thereby updating the Project's Last Update to that newer time value -- such a column would show...nothing...hmm...
In short, Would Not Recommend. Instead, I invite you to consider:
- A Task report, grouped by project, set to collapse by default, with a MAX on the TASK Last Update column so that it shows on the grouping, practically sorted by Project ASC and by TASK Last Update DESC should the user choose to expand the grid, and ideally prompted so they can find what they need
- Our Magic Reports solution, which we could tailor to give you exactly always only what you're after, in real time, within Workfront
Regards,
Doug
