<?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: Calculated column (Concatenating two different custom fields) in Assignments report returns concatenation of a different field's data  üòï in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/calculated-column-concatenating-two-different-custom-fields-in/m-p/490845#M23123</link>
    <description>&lt;P&gt;Awesome @Anthony Imgrund‚  worked like a charm and don't know why I had not tried that permutation of brackets and periods! &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Could not figure why returning values - expected a blank if there was an error. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;If only text mode featured error checking - and even better some sort of field / object explorer. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Now on to the next issue with status displaying differently in a report than on the task!&lt;/P&gt;</description>
    <pubDate>Fri, 23 Apr 2021 13:54:41 GMT</pubDate>
    <dc:creator>GregWi</dc:creator>
    <dc:date>2021-04-23T13:54:41Z</dc:date>
    <item>
      <title>Calculated column (Concatenating two different custom fields) in Assignments report returns concatenation of a different field's data  üòï</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/calculated-column-concatenating-two-different-custom-fields-in/m-p/490843#M23121</link>
      <description>&lt;P&gt;So I'm clearly doing something wrong..... but resorting to the forum for support as spent enough time in trial and error. &lt;/P&gt;&lt;P&gt;‚&lt;/P&gt;&lt;P&gt;I have an assignments report and I want to concatenate the values in 2 custom fields as below. &lt;/P&gt;&lt;P&gt;‚&lt;/P&gt;&lt;P&gt;valueexpression=CONCAT ( {DE:task:Task Type}, ' ' , {DE:task:Agile Task Type } )&lt;/P&gt;&lt;P&gt;linkedname=task&lt;/P&gt;&lt;P&gt;valueformat=customDataLabelsAsString&lt;/P&gt;&lt;P&gt;displayname=Type&lt;/P&gt;&lt;P&gt;namekey=view.relatedcolumn&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;namekeyargkey.0=task&lt;/P&gt;&lt;P&gt;namekeyargkey.1=Task Type&lt;/P&gt;&lt;P&gt;querysort=DE:task:Task Type&lt;/P&gt;&lt;P&gt;‚&lt;/P&gt;&lt;P&gt;However what I see in the report column is Task Name, the space, then the Task Name again. I would expect the column to be blank if the formula was wrong..... &lt;/P&gt;&lt;P&gt;‚&lt;/P&gt;&lt;P&gt;Have I got the DE and curly brackets wrong somehow? Separate, non calculated, standard mode columns for Task Type and Agile Task Type show exactly as expected in the report. &lt;/P&gt;&lt;P&gt;‚&lt;/P&gt;&lt;P&gt;&lt;img class="lia-deferred-image lia-image-emoji" src="https://experienceleaguecommunities.adobe.com/html/@2C7B33BADA6D3062829048A8D9586B51/emoticons/1f91e.png" alt=":crossed_fingers:" title=":crossed_fingers:" /&gt; to  see if the community can solve this one for me &lt;img class="lia-deferred-image lia-image-emoji" src="https://experienceleaguecommunities.adobe.com/html/@31B4D6D7B3510763F3CBB2AAB7997408/emoticons/1f642.png" alt=":slightly_smiling_face:" title=":slightly_smiling_face:" /&gt; &lt;/P&gt;</description>
      <pubDate>Fri, 23 Apr 2021 12:24:42 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/calculated-column-concatenating-two-different-custom-fields-in/m-p/490843#M23121</guid>
      <dc:creator>GregWi</dc:creator>
      <dc:date>2021-04-23T12:24:42Z</dc:date>
    </item>
    <item>
      <title>Re: Calculated column (Concatenating two different custom fields) in Assignments report returns concatenation of a different field's data  üòï</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/calculated-column-concatenating-two-different-custom-fields-in/m-p/490844#M23122</link>
      <description>&lt;P&gt;Hi - you were very close. The trick is that you don't use the colon for reference in a value expression. You close the bracket around each object/field and put a period. (Also, there were a lot of spaces, but that might just be the paste job. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;‚&lt;/P&gt;&lt;P&gt;valueexpression=CONCAT({task}.{DE:Task Type},"",{task}.{DE:Agile Task Type})&lt;/P&gt;&lt;P&gt;linkedname=task&lt;/P&gt;&lt;P&gt;valueformat=customDataLabelsAsString&lt;/P&gt;&lt;P&gt;displayname=Type&lt;/P&gt;&lt;P&gt;namekey=view.relatedcolumn&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;namekeyargkey.0=task&lt;/P&gt;&lt;P&gt;namekeyargkey.1=Task Type&lt;/P&gt;&lt;P&gt;querysort=DE:task:Task Type&lt;/P&gt;</description>
      <pubDate>Fri, 23 Apr 2021 13:34:59 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/calculated-column-concatenating-two-different-custom-fields-in/m-p/490844#M23122</guid>
      <dc:creator>AnthonyIm</dc:creator>
      <dc:date>2021-04-23T13:34:59Z</dc:date>
    </item>
    <item>
      <title>Re: Calculated column (Concatenating two different custom fields) in Assignments report returns concatenation of a different field's data  üòï</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/calculated-column-concatenating-two-different-custom-fields-in/m-p/490845#M23123</link>
      <description>&lt;P&gt;Awesome @Anthony Imgrund‚  worked like a charm and don't know why I had not tried that permutation of brackets and periods! &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Could not figure why returning values - expected a blank if there was an error. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;If only text mode featured error checking - and even better some sort of field / object explorer. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Now on to the next issue with status displaying differently in a report than on the task!&lt;/P&gt;</description>
      <pubDate>Fri, 23 Apr 2021 13:54:41 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/calculated-column-concatenating-two-different-custom-fields-in/m-p/490845#M23123</guid>
      <dc:creator>GregWi</dc:creator>
      <dc:date>2021-04-23T13:54:41Z</dc:date>
    </item>
  </channel>
</rss>

