<?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: Conditional formatting: Highlight cell if plannedCompletionDate is less than x weeks after entryDate in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditional-formatting-highlight-cell-if-plannedcompletiondate/m-p/494479#M26285</link>
    <description>&lt;P&gt;Hi Josh,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I don't believe this is possible. You would have to create a custom field with the calculation, then you can use that field as your comparison.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Hope that helps! &lt;/P&gt;</description>
    <pubDate>Tue, 08 Mar 2022 15:14:02 GMT</pubDate>
    <dc:creator>SarahNau</dc:creator>
    <dc:date>2022-03-08T15:14:02Z</dc:date>
    <item>
      <title>Conditional formatting: Highlight cell if plannedCompletionDate is less than x weeks after entryDate</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditional-formatting-highlight-cell-if-plannedcompletiondate/m-p/494478#M26284</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Purpose is to highlight the task request that does not come at least 3 weeks in advance.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thanks to blog entry from Kara (https://one.workfront.com/s/managed-content-blogs/workfront-wednesday-did-you-know-comparing-dates-and-more-with-conditional-forma-MCB64UAJFP6NGSFJ562WXWBB3S5Q) I got the comparison between plannedCompletionDate and entryDate to work.&lt;/P&gt;&lt;P&gt;It highlights red when plannedCompletionDate is less than entryDate, but  it seems to ignore the +15d or +3w parts.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Reaching out to community and text mode wizards for help after many failed attempts to get this to work.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;I&gt;linkedname=direct&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;querysort=plannedCompletionDate&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;styledef.case.0.comparison.icon=false&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;styledef.case.0.comparison.leftmethod=plannedCompletionDate&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;styledef.case.0.comparison.lefttext=plannedCompletionDate&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;styledef.case.0.comparison.operator=lte&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;styledef.case.0.comparison.operatortype=date&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;styledef.case.0.comparison.rightmethod=entryDate&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;styledef.case.0.comparison.righttext=FIELD:entryDate+3w&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;styledef.case.0.comparison.trueproperty.0.name=bgcolor&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;styledef.case.0.comparison.trueproperty.0.value=eac6c9&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;styledef.case.0.comparison.truetext=&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;valuefield=plannedCompletionDate&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;valueformat=atDate&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;textmode=true&lt;/I&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;John&lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
      <pubDate>Tue, 08 Mar 2022 00:06:18 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditional-formatting-highlight-cell-if-plannedcompletiondate/m-p/494478#M26284</guid>
      <dc:creator>JohnM7</dc:creator>
      <dc:date>2022-03-08T00:06:18Z</dc:date>
    </item>
    <item>
      <title>Re: Conditional formatting: Highlight cell if plannedCompletionDate is less than x weeks after entryDate</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditional-formatting-highlight-cell-if-plannedcompletiondate/m-p/494479#M26285</link>
      <description>&lt;P&gt;Hi Josh,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I don't believe this is possible. You would have to create a custom field with the calculation, then you can use that field as your comparison.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Hope that helps! &lt;/P&gt;</description>
      <pubDate>Tue, 08 Mar 2022 15:14:02 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditional-formatting-highlight-cell-if-plannedcompletiondate/m-p/494479#M26285</guid>
      <dc:creator>SarahNau</dc:creator>
      <dc:date>2022-03-08T15:14:02Z</dc:date>
    </item>
  </channel>
</rss>

