<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Project's most recently completed task and next task due in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506099#M37849</link>
    <description>&lt;P&gt;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&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;displayname=Current Task&lt;/P&gt;&lt;P&gt;listdelimiter=&amp;amp;zwj;&lt;/P&gt;&lt;P&gt;listmethod=nested(tasks).lists&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;type=iterate&lt;/P&gt;&lt;P&gt;valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," "))))&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thank you to everyone that shares knowledge!&lt;/P&gt;</description>
    <pubDate>Fri, 19 Nov 2021 21:24:29 GMT</pubDate>
    <dc:creator>RhondaTriggs</dc:creator>
    <dc:date>2021-11-19T21:24:29Z</dc:date>
    <item>
      <title>Project's most recently completed task and next task due</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506091#M37841</link>
      <description>&lt;P&gt;Hi Roy, I invite you to adapt this Project Level &lt;A href="https://one.workfront.com/s/question/0D50z00006Px4q9CAB/the-2nd-coolest-textmode-column-i-invented-this-week" alt="https://one.workfront.com/s/question/0D50z00006Px4q9CAB/the-2nd-coolest-textmode-column-i-invented-this-week" target="_blank"&gt;textmode trick&lt;/A&gt; 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&lt;/P&gt;</description>
      <pubDate>Tue, 14 Jan 2020 19:34:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506091#M37841</guid>
      <dc:creator>RoyMe</dc:creator>
      <dc:date>2020-01-14T19:34:00Z</dc:date>
    </item>
    <item>
      <title>Re: Project's most recently completed task and next task due</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506092#M37842</link>
      <description>Hi Roy, You would actually do Task Reports (and display the Project Name in the View) - Tasks Completed Last Week &amp;amp; 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.</description>
      <pubDate>Wed, 15 Jan 2020 03:23:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506092#M37842</guid>
      <dc:creator>VicAl</dc:creator>
      <dc:date>2020-01-15T03:23:00Z</dc:date>
    </item>
    <item>
      <title>Re: Project's most recently completed task and next task due</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506093#M37843</link>
      <description>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</description>
      <pubDate>Wed, 15 Jan 2020 20:33:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506093#M37843</guid>
      <dc:creator>RoyMe</dc:creator>
      <dc:date>2020-01-15T20:33:00Z</dc:date>
    </item>
    <item>
      <title>Re: Project's most recently completed task and next task due</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506094#M37844</link>
      <description>&lt;P&gt;Hi Roy, I invite you to adapt this Project Level &lt;A href="https://one.workfront.com/s/question/0D50z00006Px4q9CAB/the-2nd-coolest-textmode-column-i-invented-this-week" alt="https://one.workfront.com/s/question/0D50z00006Px4q9CAB/the-2nd-coolest-textmode-column-i-invented-this-week" target="_blank"&gt;textmode trick&lt;/A&gt; 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&lt;/P&gt;</description>
      <pubDate>Wed, 15 Jan 2020 20:43:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506094#M37844</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2020-01-15T20:43:00Z</dc:date>
    </item>
    <item>
      <title>Re: Project's most recently completed task and next task due</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506095#M37845</link>
      <description>&lt;P&gt;@Doug Den Hoed‚ - given the shift to WF One, can you provide a working link to that trick?&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Did anyone actually answer Roy's question? Because I have the same one. Trying to provide:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;a) A SINGLE most recently completed Task (or milestone) for a Project&lt;/P&gt;&lt;P&gt;b) and the SINGLE next canStart task&lt;/P&gt;</description>
      <pubDate>Thu, 02 Apr 2020 17:50:15 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506095#M37845</guid>
      <dc:creator>SethNi</dc:creator>
      <dc:date>2020-04-02T17:50:15Z</dc:date>
    </item>
    <item>
      <title>Re: Project's most recently completed task and next task due</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506096#M37846</link>
      <description>&lt;P&gt;Hi Seth,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;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).&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Doug&lt;/P&gt;</description>
      <pubDate>Thu, 02 Apr 2020 18:23:14 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506096#M37846</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2020-04-02T18:23:14Z</dc:date>
    </item>
    <item>
      <title>Re: Project's most recently completed task and next task due</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506097#M37847</link>
      <description>&lt;P&gt;Hello all, &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Great news! That thread has been brought over! I'll update the original post to have the new link as well. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;A href="https://one.workfront.com/s/question/0D50z00006Px4q9CAB/the-2nd-coolest-textmode-column-i-invented-this-week" alt="https://one.workfront.com/s/question/0D50z00006Px4q9CAB/the-2nd-coolest-textmode-column-i-invented-this-week" target="_blank"&gt;https://one.workfront.com/s/question/0D50z00006Px4q9CAB/the-2nd-coolest-textmode-column-i-invented-this-week&lt;/A&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Also, I will double check because I thought these links should have been already updated! &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Kyna&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
      <pubDate>Thu, 02 Apr 2020 18:38:12 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506097#M37847</guid>
      <dc:creator>kynabaker16</dc:creator>
      <dc:date>2020-04-02T18:38:12Z</dc:date>
    </item>
    <item>
      <title>Re: Project's most recently completed task and next task due</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506098#M37848</link>
      <description>&lt;P&gt;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! &lt;img class="lia-deferred-image lia-image-emoji" src="https://experienceleaguecommunities.adobe.com/html/@96FF2244BBA656AC79D753A4EF308B94/emoticons/1f603.png" alt=":grinning_face_with_big_eyes:" title=":grinning_face_with_big_eyes:" /&gt; &lt;/P&gt;</description>
      <pubDate>Fri, 19 Nov 2021 15:59:37 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506098#M37848</guid>
      <dc:creator>RhondaTriggs</dc:creator>
      <dc:date>2021-11-19T15:59:37Z</dc:date>
    </item>
    <item>
      <title>Re: Project's most recently completed task and next task due</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506099#M37849</link>
      <description>&lt;P&gt;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&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;displayname=Current Task&lt;/P&gt;&lt;P&gt;listdelimiter=&amp;amp;zwj;&lt;/P&gt;&lt;P&gt;listmethod=nested(tasks).lists&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;type=iterate&lt;/P&gt;&lt;P&gt;valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," "))))&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thank you to everyone that shares knowledge!&lt;/P&gt;</description>
      <pubDate>Fri, 19 Nov 2021 21:24:29 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506099#M37849</guid>
      <dc:creator>RhondaTriggs</dc:creator>
      <dc:date>2021-11-19T21:24:29Z</dc:date>
    </item>
    <item>
      <title>Re: Project's most recently completed task and next task due</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506100#M37850</link>
      <description>&lt;P&gt;Hi Rhonda,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;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. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Life's like that.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Doug&lt;/P&gt;</description>
      <pubDate>Fri, 19 Nov 2021 22:27:20 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506100#M37850</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2021-11-19T22:27:20Z</dc:date>
    </item>
    <item>
      <title>Re: Project's most recently completed task and next task due</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506101#M37851</link>
      <description>&lt;P&gt;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 &lt;img class="lia-deferred-image lia-image-emoji" src="https://experienceleaguecommunities.adobe.com/html/@96FF2244BBA656AC79D753A4EF308B94/emoticons/1f603.png" alt=":grinning_face_with_big_eyes:" title=":grinning_face_with_big_eyes:" /&gt; &lt;/P&gt;</description>
      <pubDate>Wed, 01 Dec 2021 16:39:17 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-s-most-recently-completed-task-and-next-task-due/m-p/506101#M37851</guid>
      <dc:creator>RhondaTriggs</dc:creator>
      <dc:date>2021-12-01T16:39:17Z</dc:date>
    </item>
  </channel>
</rss>

