Hi Roy, I invite you to adapt this Project Level textmode trick to pull back (I'd suggest, in two separate columns) both recently completed (e.g. Actual Completion Date within the past X days) and the next (Handoff Date not blank and Actual Completion Date blank) Tasks. Regards, Doug Doug Den Hoed - AtAppStore
Views
Replies
Total Likes
Views
Replies
Total Likes
Hi Roy, I invite you to adapt this Project Level textmode trick to pull back (I'd suggest, in two separate columns) both recently completed (e.g. Actual Completion Date within the past X days) and the next (Handoff Date not blank and Actual Completion Date blank) Tasks. Regards, Doug Doug Den Hoed - AtAppStore
Views
Replies
Total Likes
@Doug Den Hoed‚ - given the shift to WF One, can you provide a working link to that trick?
Did anyone actually answer Roy's question? Because I have the same one. Trying to provide:
a) A SINGLE most recently completed Task (or milestone) for a Project
b) and the SINGLE next canStart task
Hi Seth,
Actually, I just tried it, and the link above still works at the moment since for now, community.workfront.com is still available, for reference. I encourage you to do likewise at your earliest opportunity.
As I recall, it is scheduled to be turned off this week, but I believe that @Kyna Baker - inactive‚ confirmed that once it is, the links will also be preserved (presumably redirecting to the converted copy of the original post within one.workfront.com, or something equivalent).
Regards,
Doug
Hello, Did anyone ever figure out a solution to display only the last task completed and only the next task due? I love the solution for all completed tasks in a date range and upcoming tasks in a dat range, however, like you, Seth, I only need the single last task completed and the single next task due and cannot seem to figure out how to get what I need. Any help would be appreciated! 😃
Views
Replies
Total Likes
Hello all,
Great news! That thread has been brought over! I'll update the original post to have the new link as well.
Also, I will double check because I thought these links should have been already updated!
Kyna
I ran across this in one of the threads...(I apologize that I don't remember which one now) in any case, it uses the "can start" to only display tasks that can start based on completion of predecessors. The drawback is that if you don't use predecessors, then all of your tasks technically "can start" so you may display more than one task
displayname=Current Task
listdelimiter=‍
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," "))))
valueformat=HTML
Thank you to everyone that shares knowledge!
Views
Replies
Total Likes
Hi Rhonda,
Can Start is Handoff Date's snazzier younger brother, and either way, will help reduce the number of Tasks returned. You might also consider adding Number Of Children into the IF statement to only bring back "node" tasks (e.g. equal to zero) or "parent" tasks (e.g. greater than zero), which would reduce it further. If you happen to only be looking for handful of particular tasks (or template tasks), you could use IFIN their names so that only those tasks are considered for display. But since there is no way to aggregate (e.g. MAX) or sort the results that do come back from such type=iterate request, it will still be possible that multiple rows are returned...which is correct, technically, and effectively means there's more than one thing to do next.
Life's like that.
Regards,
Doug
Thank you for the ideas! Unfortunately, our folks used fixed dates quite a bit but you are correct, life is like that and we cannot always have everything we want in life 😃
Views
Replies
Total Likes