Level 2

Question

Project's most recently completed task and next task due

Forum|Forum|6 years ago
January 14, 2020
8 replies
1806 views

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

Workfront

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

V

VicAl1

Level 10

Hi Roy, You would actually do Task Reports (and display the Project Name in the View) - Tasks Completed Last Week & Tasks Scheduled for This Week (which includes any past open tasks). Screen shots show the filters of each report. You would add additional filters: · By a certain Project Owner, or create a Prompt, or use the $$USERID so it pulls up projects for whomever opens that report. You may want to Group by Project as well. We do all this by placing a dashboard in the Project tab (via the Template Layout). This acts as a filter for that particular project. But if you want to see all their projects in one report, the above should work. Please let me know if you need more information. Thanks.

RoyMeslerAuthor

Level 2

Thanks for your response, Vic. We actually do have a dashboard that shows tasks due today, next week,etc, which is particularly useful for those who are completing tasks to manage their work. However, the project managers (as well as their supervisors) would like to see a list of projects showing the last task on that project that was completed (regardless of when that was) and, preferably on the same report, the next task that's due on that project. It's basically a snapshot of where all projects are in the process. Roy Mesler Systems Analyst Transportation Research Board The National Academies of Sciences, Engineering, and Medicine

Doug_Den_Hoed__AtAppStore

Community Advisor

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

S

SethNi

Level 2

@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

Doug_Den_Hoed__AtAppStore

Community Advisor

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

kynabaker16

Adobe Employee

Hello all,

Great news! That thread has been brought over! I'll update the original post to have the new link as well.

https://one.workfront.com/s/question/0D50z00006Px4q9CAB/the-2nd-coolest-textmode-column-i-invented-this-week

Also, I will double check because I thought these links should have been already updated!

Kyna

RhondaGayleTX

Level 5

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=&zwj;

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!

Doug_Den_Hoed__AtAppStore

Community Advisor

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

RhondaGayleTX

Level 5

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 😃

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded