<?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: Targeted Auditing Proof Of Concept in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488006#M20604</link>
    <description>&lt;P&gt;Hi Heather,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Here's the code I am working with now in my version of the calculation field "Status History".&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;B&gt;LEFT(IF(LEFT(Status History,LEN(IF(ISBLANK(Status),"-",Status)))=Status,Status History,CONCAT(Last Updated By.Name," - ",(IF(ISBLANK(Status),"-",Status))," (",$$NOW,") | ",Status History)),2000)&lt;/B&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;This is returning some strange behavior. I created a new project, some new test tasks and went to check the Status History field on the custom form for each of the two new test tasks. I found that the user/status/datestamp was being applied more than once almost as if every update on the task to anything was causing a new datestemp occurance to be applied. . The calc is recording the default NEW status automatically and multiple times for the new task without any real status change having been done. Can anyone tell me where this code has gone wrong? I am attaching a screenshot of the new task's custom form showing the Status History field so you can see the stamp of the initial NEW status of the field and the repetition of the data.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thanks in advance for any ideas on this.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Steve&lt;span class="lia-inline-image-display-wrapper" image-alt="0690z000007ZhYwAAK.png"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/45194iA12DC4FB98614189/image-size/large?v=v2&amp;amp;px=999" role="button" title="0690z000007ZhYwAAK.png" alt="0690z000007ZhYwAAK.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
    <pubDate>Mon, 10 Jun 2019 22:29:00 GMT</pubDate>
    <dc:creator>StevenHi2</dc:creator>
    <dc:date>2019-06-10T22:29:00Z</dc:date>
    <item>
      <title>Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/487997#M20595</link>
      <description>&lt;P&gt;This morning, I did a proof of concept of "Targeted Auditing" and would like to share it with the Community.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I thought of the idea years ago but never made time for until my unsatisfying response to &lt;A href="https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=1a185039-7dff-4078-a885-5e1ba1dfbf48&amp;amp;CommunityKey=ccf3381b-a473-4ef2-9f81-4dd3244cf522&amp;amp;tab=digestviewer&amp;amp;SuccessMsg=Thank%20you%20for%20submitting%20your%20message.#bm1a185039-7dff-4078-a885-5e1ba1dfbf48" alt="https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=1a185039-7dff-4078-a885-5e1ba1dfbf48&amp;amp;CommunityKey=ccf3381b-a473-4ef2-9f81-4dd3244cf522&amp;amp;tab=digestviewer&amp;amp;SuccessMsg=Thank%20you%20for%20submitting%20your%20message.#bm1a185039-7dff-4078-a885-5e1ba1dfbf48" target="_blank"&gt;this thread&lt;/A&gt; twigged my memory. As below, my example records the changes to a particular "Target" custom text parameter in its "Target History" custom calculated parameter counter part...and to my delight, actually works!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;The formula turned out to be why-didn't-I-try-this-sooner? simple:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;B&gt;LEFT(IF(LEFT(Target History,LEN(IF(ISBLANK({Target}),"-",{Target})))={Target},Target History,CONCAT(IF(ISBLANK({Target}),"-",{Target})," (",$$NOW,") | ",{Target History})),2000)&lt;/B&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;And does the following:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;B&gt;- limits the Target History to the most recent 2000 characters (staying within the Workfront database limit)&lt;/B&gt;&lt;/P&gt;&lt;P&gt;&lt;B&gt;- checks if the current Target value&lt;/B&gt; &lt;B&gt;(treating it as "-" if it is blank) matches the front of the Target History value&lt;/B&gt;&lt;/P&gt;&lt;P&gt;&lt;B&gt;- if they match, leaves the Target History "as is"&lt;/B&gt;&lt;/P&gt;&lt;P&gt;&lt;B&gt;- if they don't match, replaces the Target History with the (latest) Target, followed by the current date, a vertical bar, and the previous Target History, which (similarly) preserves the previous value(s) and the time(s) entered&lt;/B&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I've included a screenshot below so you can visualize how it works.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;There are lots of other interesting bells and whistles you could add to what you capture (e.g. who, the time of day, etc.), so for those of you who find this of use and do make any cool enhancements, I encourage you to share them under this thread.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Have fun!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Doug&lt;span class="lia-inline-image-display-wrapper" image-alt="0690z000008KaICAA0.png"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/45855iE6986A73B793D490/image-size/large?v=v2&amp;amp;px=999" role="button" title="0690z000008KaICAA0.png" alt="0690z000008KaICAA0.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 25 Feb 2019 20:24:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/487997#M20595</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2019-02-25T20:24:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/487998#M20596</link>
      <description>&lt;P&gt;I've been playing around with this formula... and it's fabulous!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I've got this in my calculated field... LEFT(IF(LEFT(Status History,LEN(IF(ISBLANK(Status),"-",Status)))=Status,Status History,CONCAT(IF(ISBLANK(Status),"-",Status)," (",$$NOW,") | ",Status History)),2000)&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;which gives me this for the project I'm testing it on...&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0690z000008KaIHAA0.png"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/44561iA3156FB2DADE5740/image-size/large?v=v2&amp;amp;px=999" role="button" title="0690z000008KaIHAA0.png" alt="0690z000008KaIHAA0.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;I know CUR is the key for Production, GPO is the key for a custom status that we use. My question is... is there a way to replace that status key with the status names so someone other than me knows what the status history is for this project??&lt;/P&gt;</description>
      <pubDate>Thu, 04 Apr 2019 19:59:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/487998#M20596</guid>
      <dc:creator>Heather_Kulbacki</dc:creator>
      <dc:date>2019-04-04T19:59:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/487999#M20597</link>
      <description>&lt;P&gt;Why, thank you, Heather. It was a satisfying one to finally figure out.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;As for your excellent Status-in-English question, I'd suggest the crude but effective method of using a series of IF statements to transform each "Status" (e.g. CUR) to its appropriate counterpart (e.g. "Current") throughout the formula.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;The pattern looks like this, being careful to let any unknown (future) Status drop out as itself in the final else:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;B&gt;IF(Status="CUR","Current",IF(Status="PLN","Planned",IF(Status=...,...,Status)))&lt;/B&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Doug&lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
      <pubDate>Thu, 04 Apr 2019 20:24:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/487999#M20597</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2019-04-04T20:24:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488000#M20598</link>
      <description>Perfect! That worked. You're my hero Doug !! We've been trying to create a field for so long that would give us a track record of project status changes and the date of each change. This is amazing!</description>
      <pubDate>Fri, 05 Apr 2019 00:56:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488000#M20598</guid>
      <dc:creator>Heather_Kulbacki</dc:creator>
      <dc:date>2019-04-05T00:56:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488001#M20599</link>
      <description>&lt;P&gt;Huzzah!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;A Guinness in Dallas would settle us up quite nicely, Heather. &lt;img class="lia-deferred-image lia-image-emoji" src="https://experienceleaguecommunities.adobe.com/html/@96FF2244BBA656AC79D753A4EF308B94/emoticons/1f603.png" alt=":grinning_face_with_big_eyes:" title=":grinning_face_with_big_eyes:" /&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Doug&lt;/P&gt;</description>
      <pubDate>Fri, 05 Apr 2019 01:02:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488001#M20599</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2019-04-05T01:02:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488002#M20600</link>
      <description>&lt;P&gt;HI Heather,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Would you be able to share the final calculation you got working on this? I am having trouble with the positioning and format of the "status in english" IF statement translations of the root status codes. Thanks in advance.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Steve&lt;/P&gt;</description>
      <pubDate>Thu, 06 Jun 2019 17:02:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488002#M20600</guid>
      <dc:creator>StevenHi2</dc:creator>
      <dc:date>2019-06-06T17:02:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488003#M20601</link>
      <description>&lt;P&gt;Sure Steve, I actually wound up creating 2 custom fields.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;The first looks something like this and gives the current status, with additional IF statements for more custom statuses.&lt;/P&gt;&lt;P&gt;&lt;B&gt;IF(Status="INP","In Progress",IF(Status="PLN","Planning",IF(Status="CPL","Completed",Status)))&lt;/B&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I've followed that up with another calculated field to get the history as the status changes, ("Status History" and "Current Status" are the names of my custom fields)&lt;/P&gt;&lt;P&gt;&lt;B&gt;LEFT(IF(LEFT(Status History,LEN(IF(ISBLANK(Current Status),"-",Current Status)))=Current Status, Status History,CONCAT(IF(ISBLANK(Current Status),"-",Current Status)," (",$$NOW,") | ",Status History)),2000)&lt;/B&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Hope that helps.&lt;/P&gt;</description>
      <pubDate>Thu, 06 Jun 2019 17:24:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488003#M20601</guid>
      <dc:creator>Heather_Kulbacki</dc:creator>
      <dc:date>2019-06-06T17:24:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488004#M20602</link>
      <description>HI Heather, Ah, there's the rub! I was trying to embed the Status translation to English directly in the Status History field. While that may be possible I like your method and will employ it. Thanks for sharing!! Cheers, Steve Steven Hirsch The Estee Lauder Companies Inc</description>
      <pubDate>Thu, 06 Jun 2019 21:59:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488004#M20602</guid>
      <dc:creator>StevenHi2</dc:creator>
      <dc:date>2019-06-06T21:59:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488005#M20603</link>
      <description>I also initially tried to do it all in one field and struggled with that. Glad it's working for you!</description>
      <pubDate>Fri, 07 Jun 2019 14:56:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488005#M20603</guid>
      <dc:creator>Heather_Kulbacki</dc:creator>
      <dc:date>2019-06-07T14:56:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488006#M20604</link>
      <description>&lt;P&gt;Hi Heather,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Here's the code I am working with now in my version of the calculation field "Status History".&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;B&gt;LEFT(IF(LEFT(Status History,LEN(IF(ISBLANK(Status),"-",Status)))=Status,Status History,CONCAT(Last Updated By.Name," - ",(IF(ISBLANK(Status),"-",Status))," (",$$NOW,") | ",Status History)),2000)&lt;/B&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;This is returning some strange behavior. I created a new project, some new test tasks and went to check the Status History field on the custom form for each of the two new test tasks. I found that the user/status/datestamp was being applied more than once almost as if every update on the task to anything was causing a new datestemp occurance to be applied. . The calc is recording the default NEW status automatically and multiple times for the new task without any real status change having been done. Can anyone tell me where this code has gone wrong? I am attaching a screenshot of the new task's custom form showing the Status History field so you can see the stamp of the initial NEW status of the field and the repetition of the data.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thanks in advance for any ideas on this.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Steve&lt;span class="lia-inline-image-display-wrapper" image-alt="0690z000007ZhYwAAK.png"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/45194iA12DC4FB98614189/image-size/large?v=v2&amp;amp;px=999" role="button" title="0690z000007ZhYwAAK.png" alt="0690z000007ZhYwAAK.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 10 Jun 2019 22:29:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488006#M20604</guid>
      <dc:creator>StevenHi2</dc:creator>
      <dc:date>2019-06-10T22:29:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488007#M20605</link>
      <description>&lt;P&gt;Hi Steve,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;The LEFT part of the logic assumes that Status will be the first (leftmost) information within your Status Update. However, since you're currently starting with the Last Updated By.Name, when the LEFT compares the first three characters of that person's name against the current status, since they (likely) don't match, it misconstrues that there's been a status change, and creates a new (unnecessary) Status History entry.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Fortunately, it's an easy fix, if you simply rearrange your formula to match the original LEFT assumption, like this:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;LEFT(IF(LEFT(Status History,LEN(IF(ISBLANK(Status),"-",Status)))=Status,Status History,CONCAT(&lt;B&gt;(IF(ISBLANK(Status),"-",Status)),Last Updated By.Name," - ",&lt;/B&gt;" (",$$NOW,") | ",Status History)),2000)&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Doug&lt;/P&gt;</description>
      <pubDate>Tue, 11 Jun 2019 02:58:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488007#M20605</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2019-06-11T02:58:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488008#M20606</link>
      <description>On second thought, I'd suggest you CONCAT one additional dash, for legibility: LEFT(IF(LEFT(Status History,LEN(IF(ISBLANK(Status),"-",Status)))=Status,Status History,CONCAT((IF(ISBLANK(Status),"-",Status)) ," - " ,Last Updated By.Name," - "," (",$$NOW,") | ",Status History)),2000) Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! &lt;A href="https://community.workfront.com/participate/unanswered-threads" target="_blank"&gt;https://community.workfront.com/participate/unanswered-threads&lt;/A&gt;</description>
      <pubDate>Tue, 11 Jun 2019 03:08:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488008#M20606</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2019-06-11T03:08:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488009#M20607</link>
      <description>This works much better Doug. I figured it was something to do with the LEFT statement and I did not realize it was only testing the first 3 characters of the field. Thanks so much for your expertise and responsiveness. ELC is grateful to you. Cheers, Steve Steven Hirsch The Estee Lauder Companies Inc</description>
      <pubDate>Tue, 11 Jun 2019 16:40:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488009#M20607</guid>
      <dc:creator>StevenHi2</dc:creator>
      <dc:date>2019-06-11T16:40:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488010#M20608</link>
      <description>Hi Doug, I am interested in your method above to hopefully capture changes on fields within custom forms. This way we have the original entry and then the updated entry, for historical capture. My first questions to you are: How did you set this up to capture the data? Is there a form I have to create, or do I add new fields to the form(s) we are using? My second questions to you are: Is this a calculated field, and just input your formulas above? I am assuming that "Target" is the original field name and "Target History" is maybe where the calculated field is applied. Hoping you can help. Erika Garrett Gulfstream Aerospace</description>
      <pubDate>Thu, 22 Aug 2019 19:01:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488010#M20608</guid>
      <dc:creator>ErikaGa</dc:creator>
      <dc:date>2019-08-22T19:01:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488011#M20609</link>
      <description>Thanks for your interest, Erika. To answer your questions: I set up my example to capture the Target History data right next to its Target, which struck me as an intuitive location. You can do likewise and add new fields to the form(s) you are using (either "beside", as I did, or perhaps in a separate "History" section); or if you prefer, technically, the history parameters could even be on a separate form. Yes, the Target History is a calculated field, and yes, you can just input my sample formulas, replacing "Target" with your existing field name and "Target History" being the new calculated field in which the calculation is applied. Regards, Doug Doug Den Hoed - AtAppStore</description>
      <pubDate>Fri, 23 Aug 2019 06:13:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488011#M20609</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2019-08-23T06:13:00Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488012#M20610</link>
      <description>&lt;P&gt;Back by popular request from &lt;A href="https://one.workfront.com/s/question/0D70z000008PVM5/how-to-show-who-completed-a-task-in-a-report?language=en_US&amp;amp;s1oid=00D300000006HBH&amp;amp;s1nid=0DB0z000000XZP2&amp;amp;emkind=chatterCommentNotification&amp;amp;s1uid=005600000058Ym6&amp;amp;emtm=1595866239061&amp;amp;fromEmail=1&amp;amp;s1ext=0" alt="https://one.workfront.com/s/question/0D70z000008PVM5/how-to-show-who-completed-a-task-in-a-report?language=en_US&amp;amp;s1oid=00D300000006HBH&amp;amp;s1nid=0DB0z000000XZP2&amp;amp;emkind=chatterCommentNotification&amp;amp;s1uid=005600000058Ym6&amp;amp;emtm=1595866239061&amp;amp;fromEmail=1&amp;amp;s1ext=0" target="_blank"&gt;this post&lt;/A&gt;...&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;If you'd like to set up Targeted Auditing to keep track of the Status of Tasks as they change between NEW, INP, HLD, and CPL, using the full Status labels (New, In Progress, On Hold, and Complete, thanks to @Heather Kulbacki‚  for her original improvement above), INCLUDING (as is @Kristina Walton‚) the name of the person who made such an edit, I invite you to do the following:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;UL&gt;&lt;LI&gt;if you don't have one already, create a Task level custom form such as "Targeted Auditing" and add it to all Tasks of interest &lt;/LI&gt;&lt;LI&gt;on the Task level custom form, add two calculated text parameters called "Current Status" and "Status History", then save the form to make Workfront aware that both parameters now exist&lt;/LI&gt;&lt;LI&gt;paste in the calculation for each as shown below (noting that if you have more than just the four built in Task Statuses defined, you can continue the first formula's pattern to also translate such additional ones), then save the form again&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;With these in place, as each Task of Interest changes from one Status to another, the Status History will show "grow and show" a Targeted Audit record of what's changed, using the pattern of "Status Label on M/D/YYYY by User Name". &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;In this fashion, in addition to sifting through Notes records, you can quickly focus on changes to the Task Status over time.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Doug&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Current Status:&lt;/P&gt;&lt;P&gt;----------------------&lt;/P&gt;&lt;P&gt;IF(Status="NEW","New"&lt;/P&gt;&lt;P&gt;	,IF(Status="INP","In Progress"&lt;/P&gt;&lt;P&gt;		,IF(Status="HLD","On Hold"&lt;/P&gt;&lt;P&gt;			,IF(Status="CPL","Complete"&lt;/P&gt;&lt;P&gt;				,Status&lt;/P&gt;&lt;P&gt;			)&lt;/P&gt;&lt;P&gt;		)&lt;/P&gt;&lt;P&gt;	)&lt;/P&gt;&lt;P&gt;)&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Status History:&lt;/P&gt;&lt;P&gt;---------------------&lt;/P&gt;&lt;P&gt;LEFT(&lt;/P&gt;&lt;P&gt;	IF(LEFT(Status History,LEN(IF(ISBLANK(Current Status),"-",Current Status)))=Current Status&lt;/P&gt;&lt;P&gt;		, Status History&lt;/P&gt;&lt;P&gt;		,CONCAT(IF(ISBLANK(Current Status),"-",Current Status)," (",$$NOW," by ", Last Updated By.Name , ") | ",Status History)&lt;/P&gt;&lt;P&gt;	)&lt;/P&gt;&lt;P&gt;	,2000&lt;/P&gt;&lt;P&gt;)&lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
      <pubDate>Mon, 27 Jul 2020 18:20:48 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488012#M20610</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2020-07-27T18:20:48Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488013#M20611</link>
      <description>&lt;P&gt;Doug,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;What is "Target" and what is "Target history"?  Are these 2 calculated fields (date or Text) that you created?&lt;/P&gt;&lt;P&gt;Trying to do this formula in my project report - but i'm getting confused on what I put in text mode, vs what I just create as a custom field. Thanks for clarification.&lt;/P&gt;</description>
      <pubDate>Thu, 22 Oct 2020 17:59:47 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488013#M20611</guid>
      <dc:creator>BenettaPe</dc:creator>
      <dc:date>2020-10-22T17:59:47Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488014#M20612</link>
      <description>&lt;P&gt;Hi Benetta,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;In my opening post above, the &lt;I&gt;"Target" custom text parameter&lt;/I&gt; is the one that I am interesting monitoring for changes to it, and its &lt;I&gt;"Target History" custom calculated parameter counter part&lt;/I&gt; contains the formula that will accumulate the history of the changes to the target as they are made.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Over time now (thanks to @Heather Kulbacki‚ and others who've since joined in), the whole "Targeted Auditing" concept has broadened in that it can be used to track &lt;I&gt;anything &lt;/I&gt;as a Target, whether Custom Parameters (text, number, date, dropdown, etc.) or a Built In Field (e.g. Status, Project Owner, Percent Complete, etc.)&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Good luck with it, and I'm interested to hear how you make out!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Doug&lt;/P&gt;</description>
      <pubDate>Thu, 22 Oct 2020 19:36:27 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488014#M20612</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2020-10-22T19:36:27Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488015#M20613</link>
      <description>&lt;P&gt;I really love this idea, Doug! I've had this post open in a browser tab for a long while now and just got some time to noodle it out. I tried adding your Target &amp;amp; Target History fields to my Project Custom Form (in Preview environment), by copying/pasting your OP code, but I can't get it to take the calculation. Any idea what I'm missing?&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0694X00000Bz1ZnQAJ.png"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/45264i1D5CB479411EE6E8/image-size/large?v=v2&amp;amp;px=999" role="button" title="0694X00000Bz1ZnQAJ.png" alt="0694X00000Bz1ZnQAJ.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 30 Nov 2020 21:51:45 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488015#M20613</guid>
      <dc:creator>Sheri_Whitten</dc:creator>
      <dc:date>2020-11-30T21:51:45Z</dc:date>
    </item>
    <item>
      <title>Re: Targeted Auditing Proof Of Concept</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488016#M20614</link>
      <description>&lt;P&gt;Glad you like it Sherri,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;When there is a lot of bracketing in a formula such as this one, I often move it into a text editor so I can confirm everything is lined up correctly. In this case (noting that you also need to first add your Target and Target History parameters, &lt;I&gt;save &lt;/I&gt;the form so it is "aware" they are available, and &lt;I&gt;then &lt;/I&gt;paste in the self-referencing formula), I did so using my original Status / Status History version above, then substituted in your Target / Target History instead, and got the version below, which I invite you to try.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Doug&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;LEFT(&lt;/P&gt;&lt;P&gt;	IF(LEFT({DE:Target History}&lt;/P&gt;&lt;P&gt;			,LEN(IF(ISBLANK({DE:Target})&lt;/P&gt;&lt;P&gt;					,"-"&lt;/P&gt;&lt;P&gt;					,{DE:Target}&lt;/P&gt;&lt;P&gt;				)&lt;/P&gt;&lt;P&gt;			)&lt;/P&gt;&lt;P&gt;		)&lt;/P&gt;&lt;P&gt;		=Target&lt;/P&gt;&lt;P&gt;		,Target History&lt;/P&gt;&lt;P&gt;		,CONCAT(&lt;/P&gt;&lt;P&gt;			 Last Updated By.Name&lt;/P&gt;&lt;P&gt;			," - "&lt;/P&gt;&lt;P&gt;			,(&lt;/P&gt;&lt;P&gt;				IF(ISBLANK({DE:Target})&lt;/P&gt;&lt;P&gt;					,"-"&lt;/P&gt;&lt;P&gt;					,{DE:Target}&lt;/P&gt;&lt;P&gt;				)&lt;/P&gt;&lt;P&gt;			)&lt;/P&gt;&lt;P&gt;			," ("&lt;/P&gt;&lt;P&gt;			,$$NOW&lt;/P&gt;&lt;P&gt;			,") | "&lt;/P&gt;&lt;P&gt;			,{DE:Target History}&lt;/P&gt;&lt;P&gt;		)&lt;/P&gt;&lt;P&gt;	)&lt;/P&gt;&lt;P&gt;,2000)&lt;/P&gt;</description>
      <pubDate>Tue, 01 Dec 2020 05:08:26 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/targeted-auditing-proof-of-concept/m-p/488016#M20614</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2020-12-01T05:08:26Z</dc:date>
    </item>
  </channel>
</rss>

