<?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: Need help smoothing out a text mode report of projects that have not had any issues added within the last week. in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-smoothing-out-a-text-mode-report-of-projects-that-have/m-p/499794#M31544</link>
    <description>&lt;P&gt;Thanks for the tips, @NRYN R - inactive‚! I'll keep these in mind moving forward. &lt;/P&gt;</description>
    <pubDate>Mon, 20 Jul 2020 14:25:25 GMT</pubDate>
    <dc:creator>SarahMe2</dc:creator>
    <dc:date>2020-07-20T14:25:25Z</dc:date>
    <item>
      <title>Need help smoothing out a text mode report of projects that have not had any issues added within the last week.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-smoothing-out-a-text-mode-report-of-projects-that-have/m-p/499792#M31542</link>
      <description>&lt;P&gt;&lt;U&gt;Background&lt;/U&gt;: My management team has weekly meetings to evaluate all of the projects we have in Current. It's the responsibility of the Project Owners to go into their project and add an Issue (which I've set up with a queue topic) to record a weekly Status Update. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;U&gt;Problem&lt;/U&gt;: I've created a report that shows all of the Status Updates made for each project in Current, within the last week. Now, I'm trying to create the opposite of that - a list of projects that have &lt;B&gt;not &lt;/B&gt;had a Status Update (issue from queue topic) within the last week. The first report works well, but there's no easy way to tell what projects haven't added an issue. I have this code to add to a Project report but it doesn't seem to be working and I'd love some help: &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;EXISTS:A:$$EXISTSMOD=NOTEXISTS&lt;/P&gt;&lt;P&gt;EXISTS:A:$$OBJCODE=OPTASK&lt;/P&gt;&lt;P&gt;EXISTS:A:entryDate=$$TODAYb-1w&lt;/P&gt;&lt;P&gt;EXISTS:A:entryDate_Mod=between&lt;/P&gt;&lt;P&gt;EXISTS:A:entryDate_Range=$$TODAYe-1w&lt;/P&gt;&lt;P&gt;EXISTS:A:projectID=FIELD:ID&lt;/P&gt;&lt;P&gt;EXISTS:A:queueTopic:name=Status Updates&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;There are lines I will be adding to this, but only to narrow down Company and Portfolio. &lt;/P&gt;&lt;P&gt;Thanks in advance!!&lt;/P&gt;</description>
      <pubDate>Wed, 15 Jul 2020 14:43:52 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-smoothing-out-a-text-mode-report-of-projects-that-have/m-p/499792#M31542</guid>
      <dc:creator>SarahMe2</dc:creator>
      <dc:date>2020-07-15T14:43:52Z</dc:date>
    </item>
    <item>
      <title>Re: Need help smoothing out a text mode report of projects that have not had any issues added within the last week.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-smoothing-out-a-text-mode-report-of-projects-that-have/m-p/499793#M31543</link>
      <description>Hi Sarah,

First, since it’s a planned activity that someone add a weekly status update to the project, I suggest you have a task assigned to the person for each week they’re expected to do this until the completion of the project. Anything short of this will leave you with an incomplete picture of who is supposed to do the work and whether or not it was actually completed in the end.

Second, I suggest you post the weekly status updates as a note to the task. This will give you the ability to output you need in reporting to identify complete/incomplete tasks for the given timeframe. If you configure the workflow to match the human story, you’ll get all the reporting you need with ease. At Truist, we’ve come to learn that incorrect use of issues to capture work is always a mistake, and that they should always be resolved by another project/task/issue in the system if work was actually performed.

I’ll have much more to share on best practices when I present the Truist Workfront Center of Excellence to the community in due time.

Thanks,
Narayan (Truist)</description>
      <pubDate>Wed, 15 Jul 2020 20:24:53 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-smoothing-out-a-text-mode-report-of-projects-that-have/m-p/499793#M31543</guid>
      <dc:creator>NRYNR</dc:creator>
      <dc:date>2020-07-15T20:24:53Z</dc:date>
    </item>
    <item>
      <title>Re: Need help smoothing out a text mode report of projects that have not had any issues added within the last week.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-smoothing-out-a-text-mode-report-of-projects-that-have/m-p/499794#M31544</link>
      <description>&lt;P&gt;Thanks for the tips, @NRYN R - inactive‚! I'll keep these in mind moving forward. &lt;/P&gt;</description>
      <pubDate>Mon, 20 Jul 2020 14:25:25 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-smoothing-out-a-text-mode-report-of-projects-that-have/m-p/499794#M31544</guid>
      <dc:creator>SarahMe2</dc:creator>
      <dc:date>2020-07-20T14:25:25Z</dc:date>
    </item>
    <item>
      <title>Re: Need help smoothing out a text mode report of projects that have not had any issues added within the last week.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-smoothing-out-a-text-mode-report-of-projects-that-have/m-p/499795#M31545</link>
      <description>&lt;P&gt;I would leave out that last line in the exists code, Sarah... or add a modifier to it (depending on what you want to do?).&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Guessing at what you want to do: leave it out of exists, and put it in the regular filter code with company and portfolio. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;i.e. regular reporting code which can be done in standard mode: you're filtering for projects from a specific company and portfolio with a queue topic name containing the text "status update". Then switch to text mode, and plug in your amended exists statement (which seems to work, by the way -- I plugged it into my sandbox minus the queue topic line and it pulled up what I was expecting)&lt;/P&gt;</description>
      <pubDate>Mon, 20 Jul 2020 15:44:47 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-smoothing-out-a-text-mode-report-of-projects-that-have/m-p/499795#M31545</guid>
      <dc:creator>skyehansen</dc:creator>
      <dc:date>2020-07-20T15:44:47Z</dc:date>
    </item>
  </channel>
</rss>

