<?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 with a Calculated Field Expression in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483241#M16010</link>
    <description>&lt;P&gt;Hi Kundan. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;You can use the CONCAT function to combine the reference # and project name. Below I have the two separated by " - " but you can change that to what works for you in the valueexpression line. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;displayname=Reference + Name&lt;/P&gt;&lt;P&gt;linked.valuefield=name&lt;/P&gt;&lt;P&gt;linked.valueformat=HTML&lt;/P&gt;&lt;P&gt;namekey=name&lt;/P&gt;&lt;P&gt;querysort=name&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;valueexpression=CONCAT({referenceNumber}," - ",{name})&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I am not sure if you still want to restrict to the first 10 characters as well. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;UL&gt;&lt;LI&gt;This option restricts to 10 characters including the reference #. This results in very little of the actual project name. &lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;valueexpression=LEFT(CONCAT({referenceNumber}," - ",{name}),10)&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;UL&gt;&lt;LI&gt;This option would restrict only the project name to 10 characters and then add the reference number to the front. &lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;valueexpression=CONCAT({referenceNumber}," - ",LEFT({name},10))&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Hope this helps.&lt;/P&gt;&lt;P&gt;-Ali&lt;/P&gt;</description>
    <pubDate>Mon, 21 Mar 2022 14:25:13 GMT</pubDate>
    <dc:creator>apentico</dc:creator>
    <dc:date>2022-03-21T14:25:13Z</dc:date>
    <item>
      <title>Need help with a Calculated Field Expression</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483235#M16004</link>
      <description>&lt;P&gt;I'm trying to create a custom artwork file name based on the name of the project name entered into our system and reference number. Is there a custom expression I can use to remove the spaces in a project name or replace the spaces with an underscore?&lt;/P&gt;</description>
      <pubDate>Sun, 13 Mar 2022 01:58:58 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483235#M16004</guid>
      <dc:creator>SarahSm</dc:creator>
      <dc:date>2022-03-13T01:58:58Z</dc:date>
    </item>
    <item>
      <title>Re: Need help with a Calculated Field Expression</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483236#M16005</link>
      <description>&lt;P&gt;Hi Sarah. You can use Replace to remove the spaces. The bolded section in the equation below is what I used on a project custom form that will replace spaces with an underscore. The equation would need to change a bit if you are adding the custom field to a different object or if you are just creating a calculated column in a report/view. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;CONCAT(Reference Number,&lt;B&gt;REPLACE(Name," ","_")&lt;/B&gt;)&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;The result for a Project A with a reference # of 123 would be: 123Project_A&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Hope this helps!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
      <pubDate>Mon, 14 Mar 2022 17:49:26 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483236#M16005</guid>
      <dc:creator>apentico</dc:creator>
      <dc:date>2022-03-14T17:49:26Z</dc:date>
    </item>
    <item>
      <title>Re: Need help with a Calculated Field Expression</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483237#M16006</link>
      <description>&lt;P&gt;Thank you so much!&lt;/P&gt;</description>
      <pubDate>Mon, 14 Mar 2022 21:26:01 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483237#M16006</guid>
      <dc:creator>SarahSm</dc:creator>
      <dc:date>2022-03-14T21:26:01Z</dc:date>
    </item>
    <item>
      <title>Re: Need help with a Calculated Field Expression</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483238#M16007</link>
      <description>&lt;P&gt;Thanks a lot @Ali Pentico‚ for sharing above expression. But it is possible to restrict until first 10 letters or first two words only. Could you share the expression for similar request? Also, if this creates a clickable link that will be excellent.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Mvh&lt;/P&gt;&lt;P&gt;Kundan.&lt;/P&gt;</description>
      <pubDate>Tue, 15 Mar 2022 10:05:24 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483238#M16007</guid>
      <dc:creator>Kundanism</dc:creator>
      <dc:date>2022-03-15T10:05:24Z</dc:date>
    </item>
    <item>
      <title>Re: Need help with a Calculated Field Expression</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483239#M16008</link>
      <description>&lt;P&gt;Hi Kundan. To get the first 10 characters, I would use the LEFT function. Using LEFT(Name,10) on a Project would give you the first 10 characters of the project name. Below is the text mode I used to create a column in a project report that would show the first 10 characters of the project name and then still link to the project. I bolded the part that does the link.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;displayname=Shortened Name&lt;/P&gt;&lt;P&gt;&lt;B&gt;linked.valuefield=name&lt;/B&gt;&lt;/P&gt;&lt;P&gt;&lt;B&gt;linked.valueformat=HTML&lt;/B&gt;&lt;/P&gt;&lt;P&gt;namekey=name&lt;/P&gt;&lt;P&gt;querysort=name&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;valueexpression=LEFT({name},10)&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Hope this helps.&lt;/P&gt;&lt;P&gt;-Ali&lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
      <pubDate>Tue, 15 Mar 2022 17:13:23 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483239#M16008</guid>
      <dc:creator>apentico</dc:creator>
      <dc:date>2022-03-15T17:13:23Z</dc:date>
    </item>
    <item>
      <title>Re: Need help with a Calculated Field Expression</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483240#M16009</link>
      <description>&lt;P&gt;Thanks a lot @Ali Pentico‚ .&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I was trying to merge the above two, i.e. reference number together woth project name but no success.&lt;/P&gt;&lt;P&gt;Any idea?&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Have a nice weekend!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;mvh&lt;/P&gt;&lt;P&gt;Kundan.&lt;/P&gt;</description>
      <pubDate>Fri, 18 Mar 2022 13:48:57 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483240#M16009</guid>
      <dc:creator>Kundanism</dc:creator>
      <dc:date>2022-03-18T13:48:57Z</dc:date>
    </item>
    <item>
      <title>Re: Need help with a Calculated Field Expression</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483241#M16010</link>
      <description>&lt;P&gt;Hi Kundan. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;You can use the CONCAT function to combine the reference # and project name. Below I have the two separated by " - " but you can change that to what works for you in the valueexpression line. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;displayname=Reference + Name&lt;/P&gt;&lt;P&gt;linked.valuefield=name&lt;/P&gt;&lt;P&gt;linked.valueformat=HTML&lt;/P&gt;&lt;P&gt;namekey=name&lt;/P&gt;&lt;P&gt;querysort=name&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;valueexpression=CONCAT({referenceNumber}," - ",{name})&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I am not sure if you still want to restrict to the first 10 characters as well. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;UL&gt;&lt;LI&gt;This option restricts to 10 characters including the reference #. This results in very little of the actual project name. &lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;valueexpression=LEFT(CONCAT({referenceNumber}," - ",{name}),10)&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;UL&gt;&lt;LI&gt;This option would restrict only the project name to 10 characters and then add the reference number to the front. &lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;valueexpression=CONCAT({referenceNumber}," - ",LEFT({name},10))&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Hope this helps.&lt;/P&gt;&lt;P&gt;-Ali&lt;/P&gt;</description>
      <pubDate>Mon, 21 Mar 2022 14:25:13 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483241#M16010</guid>
      <dc:creator>apentico</dc:creator>
      <dc:date>2022-03-21T14:25:13Z</dc:date>
    </item>
    <item>
      <title>Re: Need help with a Calculated Field Expression</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483242#M16011</link>
      <description>&lt;P&gt;Excellent and a great help @Ali Pentico‚ .&lt;/P&gt;&lt;P&gt;I am testing this and will inform the result soon.&lt;/P&gt;&lt;P&gt;Have a nice evening!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Mvh&lt;/P&gt;&lt;P&gt;Kundan.&lt;/P&gt;</description>
      <pubDate>Mon, 21 Mar 2022 17:34:07 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483242#M16011</guid>
      <dc:creator>Kundanism</dc:creator>
      <dc:date>2022-03-21T17:34:07Z</dc:date>
    </item>
    <item>
      <title>Re: Need help with a Calculated Field Expression</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483243#M16012</link>
      <description>&lt;P&gt;Hi @Ali Pentico‚ &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thank you, it works as you mentioned.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Have a nice day!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Mvh&lt;/P&gt;&lt;P&gt;Kundan.&lt;/P&gt;</description>
      <pubDate>Tue, 29 Mar 2022 07:33:15 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/need-help-with-a-calculated-field-expression/m-p/483243#M16012</guid>
      <dc:creator>Kundanism</dc:creator>
      <dc:date>2022-03-29T07:33:15Z</dc:date>
    </item>
  </channel>
</rss>

