<?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: How can I pull specific milestones dates that are reached into a project list report? in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-can-i-pull-specific-milestones-dates-that-are-reached-into-a/m-p/507794#M39544</link>
    <description>&lt;P&gt; No problem at all. I appreciate you taking the time to tech me. This worked great so thank you again for all your help here.&lt;/P&gt;</description>
    <pubDate>Tue, 16 Feb 2021 16:37:23 GMT</pubDate>
    <dc:creator>TrishaGr</dc:creator>
    <dc:date>2021-02-16T16:37:23Z</dc:date>
    <item>
      <title>How can I pull specific milestones dates that are reached into a project list report?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-can-i-pull-specific-milestones-dates-that-are-reached-into-a/m-p/507790#M39540</link>
      <description>&lt;P&gt;Is it possible to pull the dates into a report based on the task date linked to specific milestones? We want to report on a few different dates based on certain milestones being reached.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;For example, we would like to report on the date the project rollout was completed which is in the project plan and tied to a milestone called 'Launched' but this one is easy cause it also equals the Planned Completion Date. We also want to show the date the technology was released which is in the project plan as a task called Deployment to Production and is linked to the milestone called 'Tech Release'. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Can you direct me to documentation or training that shows me how to report on milestone dates in a project report?&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I see the milestone report but I need to be able to view other project data on the report that the milestone reports do not show. I want to add milestone dates to a report that lists the projects and project details as well as the dates that are important.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;The report I would like to pull the dates into is shown in the attached screenshot and is a project report.&lt;/P&gt;</description>
      <pubDate>Tue, 12 Jan 2021 20:42:28 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-can-i-pull-specific-milestones-dates-that-are-reached-into-a/m-p/507790#M39540</guid>
      <dc:creator>TrishaGr</dc:creator>
      <dc:date>2021-01-12T20:42:28Z</dc:date>
    </item>
    <item>
      <title>Re: How can I pull specific milestones dates that are reached into a project list report?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-can-i-pull-specific-milestones-dates-that-are-reached-into-a/m-p/507791#M39541</link>
      <description>&lt;P&gt;Hi Trisha,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Since you want to pull task information into a project report (as milestones are associated with tasks only), you will need to use a bit of text mode to get to and display this data. In your project report, if you create a new column, switch to text mode and insert the following code.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;displayname=Milestones&lt;/P&gt;&lt;P&gt;listdelimiter=&amp;lt;br&amp;gt;&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(!ISBLANK({milestone}.{ID}),CONCAT({milestone}.{name}," | ","Actual Completion Date"," = ",{actualCompletionDate}),"")&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;This code tells Workfront to look through all of the tasks in a project and provide a list of the tasks that have a milestone associated with them, and in that list output the milestone name and the actual completion date of that milestone.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Hope that helps! Please shout if you have any questions.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Best Regards,&lt;/P&gt;&lt;P&gt;Rich. &lt;/P&gt;</description>
      <pubDate>Tue, 12 Jan 2021 22:35:55 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-can-i-pull-specific-milestones-dates-that-are-reached-into-a/m-p/507791#M39541</guid>
      <dc:creator>RichardLe1</dc:creator>
      <dc:date>2021-01-12T22:35:55Z</dc:date>
    </item>
    <item>
      <title>Re: How can I pull specific milestones dates that are reached into a project list report?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-can-i-pull-specific-milestones-dates-that-are-reached-into-a/m-p/507792#M39542</link>
      <description>&lt;P&gt;So if I wanted to do the Planned Completion Date instead of actual would I just replace it to look like this? I pulled the milestone ID and Milestone name and added them in this.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;displayname=Milestones&lt;/P&gt;&lt;P&gt;listdelimiter=&amp;lt;br&amp;gt;&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(!ISBLANK({5ff4f64305be4d2950d0f65e475f0f38}),CONCAT({{milestone}.{name}} | ","Planned Completion Date"," = ",{plannedCompletionDate}),"")&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;</description>
      <pubDate>Thu, 28 Jan 2021 02:06:27 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-can-i-pull-specific-milestones-dates-that-are-reached-into-a/m-p/507792#M39542</guid>
      <dc:creator>TrishaGr</dc:creator>
      <dc:date>2021-01-28T02:06:27Z</dc:date>
    </item>
    <item>
      <title>Re: How can I pull specific milestones dates that are reached into a project list report?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-can-i-pull-specific-milestones-dates-that-are-reached-into-a/m-p/507793#M39543</link>
      <description>&lt;P&gt;Hi Trisha,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Really sorry for the slow reply, I've just noticed I didn't respond to your follow up question!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;If you are only wanting to pull in one specific milestone into the report (as opposed to all of them), then your code would look like the below:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;displayname=Milestones&lt;/P&gt;&lt;P&gt;listdelimiter=&amp;lt;br&amp;gt;&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({milestone}.{ID}="5ff4f64305be4d2950d0f65e475f0f38",CONCAT({milestone}.{name}," | ","Planned Completion Date"," = ",{plannedCompletionDate}),"")&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Best Regards,&lt;/P&gt;&lt;P&gt;Rich. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
      <pubDate>Tue, 09 Feb 2021 23:23:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-can-i-pull-specific-milestones-dates-that-are-reached-into-a/m-p/507793#M39543</guid>
      <dc:creator>RichardLe1</dc:creator>
      <dc:date>2021-02-09T23:23:00Z</dc:date>
    </item>
    <item>
      <title>Re: How can I pull specific milestones dates that are reached into a project list report?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-can-i-pull-specific-milestones-dates-that-are-reached-into-a/m-p/507794#M39544</link>
      <description>&lt;P&gt; No problem at all. I appreciate you taking the time to tech me. This worked great so thank you again for all your help here.&lt;/P&gt;</description>
      <pubDate>Tue, 16 Feb 2021 16:37:23 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-can-i-pull-specific-milestones-dates-that-are-reached-into-a/m-p/507794#M39544</guid>
      <dc:creator>TrishaGr</dc:creator>
      <dc:date>2021-02-16T16:37:23Z</dc:date>
    </item>
  </channel>
</rss>

