<?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: Tasks in a Column within a Project Report in Workfront Discussions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-discussions/tasks-in-a-column-within-a-project-report/m-p/538724#M8</link>
    <description>&lt;P&gt;Hi David,&lt;/P&gt;
&lt;P&gt;I'm new to using TextMode, but it looks like you might have extra spaces inside your quotation marks around "Test1" so it might not be finding the name of your project to return results. I'd start there at least and see if that resolves it.&lt;/P&gt;</description>
    <pubDate>Tue, 02 Aug 2022 14:46:05 GMT</pubDate>
    <dc:creator>RachealRice</dc:creator>
    <dc:date>2022-08-02T14:46:05Z</dc:date>
    <item>
      <title>Tasks in a Column within a Project Report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-discussions/tasks-in-a-column-within-a-project-report/m-p/538526#M3</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;
&lt;P&gt;I am struggling to get this to work:&lt;/P&gt;
&lt;P&gt;displayname=Test&lt;BR /&gt;listdelimiter=&amp;lt;div&amp;gt;&lt;BR /&gt;listmethod=nested(tasks).lists&lt;BR /&gt;textmode=true&lt;BR /&gt;type=iterate&lt;BR /&gt;valueexpression=IF(ISBLANK({actualCompletionDate}),IF({numberOfChildren}=0,IF(CONTAINS(" Test1 ",{name}),CONCAT({plannedCompletionDate}," - ",{name}),IF(CONTAINS(" Test1 ",{name}),CONCAT({plannedCompletionDate}," - ",{name})))))&lt;BR /&gt;valueformat=HTML&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I am trying to pull a Task within a project that is named Test1 to a column in a project level report and see it's status, but when I do this the field is blank.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thank you,&lt;/P&gt;
&lt;P&gt;David&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 01 Aug 2022 23:29:05 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-discussions/tasks-in-a-column-within-a-project-report/m-p/538526#M3</guid>
      <dc:creator>thisisxeney</dc:creator>
      <dc:date>2022-08-01T23:29:05Z</dc:date>
    </item>
    <item>
      <title>Re: Tasks in a Column within a Project Report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-discussions/tasks-in-a-column-within-a-project-report/m-p/538724#M8</link>
      <description>&lt;P&gt;Hi David,&lt;/P&gt;
&lt;P&gt;I'm new to using TextMode, but it looks like you might have extra spaces inside your quotation marks around "Test1" so it might not be finding the name of your project to return results. I'd start there at least and see if that resolves it.&lt;/P&gt;</description>
      <pubDate>Tue, 02 Aug 2022 14:46:05 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-discussions/tasks-in-a-column-within-a-project-report/m-p/538724#M8</guid>
      <dc:creator>RachealRice</dc:creator>
      <dc:date>2022-08-02T14:46:05Z</dc:date>
    </item>
    <item>
      <title>Re: Tasks in a Column within a Project Report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-discussions/tasks-in-a-column-within-a-project-report/m-p/538811#M15</link>
      <description>&lt;P&gt;Hello Racheal,&lt;/P&gt;
&lt;P&gt;I also tried removing the spaces before that and still did not pull my tasks either.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 02 Aug 2022 16:33:57 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-discussions/tasks-in-a-column-within-a-project-report/m-p/538811#M15</guid>
      <dc:creator>thisisxeney</dc:creator>
      <dc:date>2022-08-02T16:33:57Z</dc:date>
    </item>
    <item>
      <title>Re: Tasks in a Column within a Project Report</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-discussions/tasks-in-a-column-within-a-project-report/m-p/538888#M20</link>
      <description>&lt;P&gt;Hi David,&lt;/P&gt;
&lt;P&gt;&lt;BR /&gt;I cut down on the IF statements (I'm not that great with them yet). This might work for you&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;displayname=Current Task(s)&lt;BR /&gt;listdelimiter=&amp;lt;br&amp;gt;&lt;BR /&gt;listmethod=nested(tasks).lists&lt;BR /&gt;textmode=true&lt;BR /&gt;type=iterate&lt;BR /&gt;valueexpression=IF({name}="Test 1",CONCAT(" * ",{name}," - " ,{plannedCompletionDate}),"")&lt;BR /&gt;valueformat=HTML&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Project data&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ry_93E9BE_1-1659473026701.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/46009i8EB41C886D62DD74/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Ry_93E9BE_1-1659473026701.png" alt="Ry_93E9BE_1-1659473026701.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;result&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ry_93E9BE_0-1659472938628.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/46007i95D61BC93755BC0B/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Ry_93E9BE_0-1659472938628.png" alt="Ry_93E9BE_0-1659472938628.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 02 Aug 2022 20:44:10 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-discussions/tasks-in-a-column-within-a-project-report/m-p/538888#M20</guid>
      <dc:creator>RyanK1</dc:creator>
      <dc:date>2022-08-02T20:44:10Z</dc:date>
    </item>
  </channel>
</rss>

