<?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: Conditionally Highlighting on Column Values in a View in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469543#M2687</link>
    <description>&lt;P&gt;Hi Nick- you should be able to achieve all of this via the Column Rule on your report columns.  In Report Edit- click on a column header, then you will see Advanced Options- add Column Rules to highlight for each of the metrics you are looking for.  I like to adjust it from there, so next steps (i.e. if you want varying red shades), go back into the column, Edit Text mode, change the color of the background/font to a brighter/bolder color by looking up the CSS code for a color you want.  For example:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;This is the Workfront text mode code for background color of red is a light red:&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.trueproperty.0.name=bgcolor&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.trueproperty.0.value=eac6c9&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Google CSS colors, pick the red you want, and replace just the code and save&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;</description>
    <pubDate>Thu, 14 Jan 2021 15:06:28 GMT</pubDate>
    <dc:creator>SaraTo1</dc:creator>
    <dc:date>2021-01-14T15:06:28Z</dc:date>
    <item>
      <title>Conditionally Highlighting on Column Values in a View</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469542#M2686</link>
      <description>&lt;P&gt;Hi WF Community,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Wondering if anyone can help me with text mode that will assist in adding conditionally highlighting to a view on a project report?&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;OL&gt;&lt;LI&gt;% complete = 100% AND status is NOT complete (highlight background or text in red)&lt;/LI&gt;&lt;LI&gt;start date before today AND status = planning (highlight background or text in red)&lt;/LI&gt;&lt;LI&gt;end date is before today AND status does not = complete (highlight background or text in red)&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thanks.&lt;/P&gt;&lt;P&gt;Nick&lt;/P&gt;</description>
      <pubDate>Wed, 13 Jan 2021 21:03:41 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469542#M2686</guid>
      <dc:creator>NickVa1</dc:creator>
      <dc:date>2021-01-13T21:03:41Z</dc:date>
    </item>
    <item>
      <title>Re: Conditionally Highlighting on Column Values in a View</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469543#M2687</link>
      <description>&lt;P&gt;Hi Nick- you should be able to achieve all of this via the Column Rule on your report columns.  In Report Edit- click on a column header, then you will see Advanced Options- add Column Rules to highlight for each of the metrics you are looking for.  I like to adjust it from there, so next steps (i.e. if you want varying red shades), go back into the column, Edit Text mode, change the color of the background/font to a brighter/bolder color by looking up the CSS code for a color you want.  For example:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;This is the Workfront text mode code for background color of red is a light red:&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.trueproperty.0.name=bgcolor&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.trueproperty.0.value=eac6c9&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Google CSS colors, pick the red you want, and replace just the code and save&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;</description>
      <pubDate>Thu, 14 Jan 2021 15:06:28 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469543#M2687</guid>
      <dc:creator>SaraTo1</dc:creator>
      <dc:date>2021-01-14T15:06:28Z</dc:date>
    </item>
    <item>
      <title>Re: Conditionally Highlighting on Column Values in a View</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469544#M2688</link>
      <description>&lt;P&gt;Thanks, Sara.&lt;/P&gt;&lt;P&gt;I'm familiar what you described.  On my end, it's the part where there are multiple conditions that need to be met (AND statement).  E.g. % complete = 100% AND status is NOT complete, then highlight status field in red.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Not sure how to work that into the text mode code for conditional highlighting, as noted &lt;A href="https://one.workfront.com/s/document-item?bundleId=workfront-classic&amp;amp;topicId=Content%2FReports_and_Dashboards%2FReports%2FText_Mode%2Fuse-conditional-formatting-text-mode.html&amp;amp;_LANG=en" alt="https://one.workfront.com/s/document-item?bundleId=workfront-classic&amp;amp;topicId=Content%2FReports_and_Dashboards%2FReports%2FText_Mode%2Fuse-conditional-formatting-text-mode.html&amp;amp;_LANG=en" target="_blank"&gt;here&lt;/A&gt;.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I'm using a workaround - the addition of custom columns with an IF &amp;amp;&amp;amp; valueexpression and a text result, but I'm still curious how to use conditional highlighting on existing native fields when multiple criteria is required.&lt;/P&gt;</description>
      <pubDate>Thu, 14 Jan 2021 18:07:42 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469544#M2688</guid>
      <dc:creator>NickVa1</dc:creator>
      <dc:date>2021-01-14T18:07:42Z</dc:date>
    </item>
    <item>
      <title>Re: Conditionally Highlighting on Column Values in a View</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469545#M2689</link>
      <description>&lt;P&gt;@Doug Den Hoed‚  - hate to bother you, but based on a link you sent me to to wf-pro.com for something else, I found &lt;A href="https://wf-pro.com/home/training/text-mode-examples/" alt="https://wf-pro.com/home/training/text-mode-examples/" target="_blank"&gt;an example&lt;/A&gt; (Ref # 14602) of conditional highlighting a field value, and it includes a valueexpression that allows for an IF statement.  I'm thinking this could work for my above asks; however, the text mode code I modified doesn't seem to be working.  Wondering if you could take a quick peek when you get a moment?&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;B&gt;Ask&lt;/B&gt;: conditionally highlight a view on a project report&lt;/P&gt;&lt;P&gt;&lt;B&gt;Scenario&lt;/B&gt;: % complete = 100% AND status is NOT complete (highlight background or text in red)&lt;/P&gt;&lt;P&gt;&lt;B&gt;Text mode...&lt;/B&gt;&lt;/P&gt;&lt;P&gt;displayname=% Complete&lt;/P&gt;&lt;P&gt;linkedname=direct&lt;/P&gt;&lt;P&gt;namekey=percentcomp&lt;/P&gt;&lt;P&gt;querysort=percentComplete&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.icon=false&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.leftmethod=percentComplete&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.lefttext=percentComplete&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.operator=notblank&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.operatortype=double&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.righttext=&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.trueproperty.0.name=bgcolor&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.trueproperty.0.value=eac6c9&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.truetext=&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;valueexpression=IF({percentComplete}="100"&amp;amp;&amp;amp;{status}!="CPL")&lt;/P&gt;&lt;P&gt;valueformat=doubleAsPercentRounded&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thanks, regardless of whether you manage to take a look or not.&lt;/P&gt;&lt;P&gt;Nick&lt;/P&gt;</description>
      <pubDate>Tue, 26 Jan 2021 17:25:29 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469545#M2689</guid>
      <dc:creator>NickVa1</dc:creator>
      <dc:date>2021-01-26T17:25:29Z</dc:date>
    </item>
    <item>
      <title>Re: Conditionally Highlighting on Column Values in a View</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469546#M2690</link>
      <description>&lt;P&gt;Hi Nick,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Try adding this column to your Project View; I set it up on the % Complete field (and quite like it), but you can easily copy only (but all of) the styledef. rows and paste them onto the tail end of any column (in text mode) you wish.&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;descriptionkey=percentcomplete&lt;/P&gt;&lt;P&gt;linkedname=direct&lt;/P&gt;&lt;P&gt;listsort=doubleAsDouble(percentComplete)&lt;/P&gt;&lt;P&gt;namekey=percentComplete&lt;/P&gt;&lt;P&gt;querysort=percentComplete&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.icon=false&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.leftmethod=percentComplete&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.lefttext=percentComplete&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.operator=lt&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.operatortype=double&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.righttext=100&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.truetext=&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.icon=false&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.leftmethod=statusEquatesWith&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.lefttext=statusEquatesWith&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.operator=in&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.operatortype=string&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.righttext=CPL&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.truetext=&lt;/P&gt;&lt;P&gt;styledef.case.2.comparison.icon=false&lt;/P&gt;&lt;P&gt;styledef.case.2.comparison.leftmethod=percentComplete&lt;/P&gt;&lt;P&gt;styledef.case.2.comparison.lefttext=percentComplete&lt;/P&gt;&lt;P&gt;styledef.case.2.comparison.operator=eq&lt;/P&gt;&lt;P&gt;styledef.case.2.comparison.operatortype=double&lt;/P&gt;&lt;P&gt;styledef.case.2.comparison.righttext=100&lt;/P&gt;&lt;P&gt;styledef.case.2.comparison.trueproperty.0.name=bgcolor&lt;/P&gt;&lt;P&gt;styledef.case.2.comparison.trueproperty.0.value=ff0000&lt;/P&gt;&lt;P&gt;styledef.case.2.comparison.truetext=&lt;/P&gt;&lt;P&gt;textmode=false&lt;/P&gt;&lt;P&gt;type=tile&lt;/P&gt;&lt;P&gt;valuefield=percentComplete&lt;/P&gt;&lt;P&gt;valueformat=asPercent&lt;/P&gt;&lt;P&gt;width=80&lt;/P&gt;&lt;P&gt;tile.name=component.percentcompletelistview&lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
      <pubDate>Wed, 27 Jan 2021 22:28:58 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469546#M2690</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2021-01-27T22:28:58Z</dc:date>
    </item>
    <item>
      <title>Re: Conditionally Highlighting on Column Values in a View</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469547#M2691</link>
      <description>&lt;P&gt;Thanks, Doug!  &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;When looking at my criteria for % complete = 100% AND status is NOT complete, your text mode code works in that it highlights the Percent Complete field when it's 100%, but it doesn't seem to be accounting for the the Status field not equaling Complete.   I tried modifying your code, but I'm coming up empty.&lt;/P&gt;</description>
      <pubDate>Thu, 28 Jan 2021 14:47:45 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469547#M2691</guid>
      <dc:creator>NickVa1</dc:creator>
      <dc:date>2021-01-28T14:47:45Z</dc:date>
    </item>
    <item>
      <title>Re: Conditionally Highlighting on Column Values in a View</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469548#M2692</link>
      <description>&lt;P&gt;Hey Nick,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I wasn't able to get this to work in the percent complete column, but in a status column, I was able to get the complete &amp;amp; 100% grey (white wouldn't work), and the not complete &amp;amp; 100% red with the standard rules:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0694X00000C1BKQQA3.jpg"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/44621iC0D7E923B250DA2B/image-size/large?v=v2&amp;amp;px=999" role="button" title="0694X00000C1BKQQA3.jpg" alt="0694X00000C1BKQQA3.jpg" /&gt;&lt;/span&gt;It was super finicky and if I made changes to them after creating (I forgot to apply to the entire row), it stopped working, not sure why.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Here is the text mode:&lt;/P&gt;&lt;P&gt;enumclass=com.attask.common.constants.ProjectStatusEnum&lt;/P&gt;&lt;P&gt;linkedname=direct&lt;/P&gt;&lt;P&gt;namekey=status&lt;/P&gt;&lt;P&gt;querysort=status&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.icon=false&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.isrowcase=true&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.leftmethod=status&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.lefttext=status&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.operator=in&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.operatortype=string&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.righttext=CPL&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.trueproperty.0.name=bgcolor&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.trueproperty.0.value=e8e8e8&lt;/P&gt;&lt;P&gt;styledef.case.0.comparison.truetext=&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.icon=false&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.isrowcase=true&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.leftmethod=percentComplete&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.lefttext=percentComplete&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.operator=eq&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.operatortype=double&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.righttext=100&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.trueproperty.0.name=bgcolor&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.trueproperty.0.value=eac6c9&lt;/P&gt;&lt;P&gt;styledef.case.1.comparison.truetext=&lt;/P&gt;&lt;P&gt;textmode=false&lt;/P&gt;&lt;P&gt;type=enum&lt;/P&gt;&lt;P&gt;valuefield=status&lt;/P&gt;&lt;P&gt;valueformat=val&lt;/P&gt;&lt;P&gt;row.0.styledef.applyallcases=true&lt;/P&gt;&lt;P&gt;row.0.styledef.case.0.comparison.icon=false&lt;/P&gt;&lt;P&gt;row.0.styledef.case.0.comparison.isrowcase=true&lt;/P&gt;&lt;P&gt;row.0.styledef.case.0.comparison.leftmethod=status&lt;/P&gt;&lt;P&gt;row.0.styledef.case.0.comparison.lefttext=status&lt;/P&gt;&lt;P&gt;row.0.styledef.case.0.comparison.operator=in&lt;/P&gt;&lt;P&gt;row.0.styledef.case.0.comparison.operatortype=string&lt;/P&gt;&lt;P&gt;row.0.styledef.case.0.comparison.righttext=CPL&lt;/P&gt;&lt;P&gt;row.0.styledef.case.0.comparison.trueproperty.0.name=bgcolor&lt;/P&gt;&lt;P&gt;row.0.styledef.case.0.comparison.trueproperty.0.value=e8e8e8&lt;/P&gt;&lt;P&gt;row.0.styledef.case.0.comparison.truetext=&lt;/P&gt;&lt;P&gt;row.0.styledef.case.1.comparison.icon=false&lt;/P&gt;&lt;P&gt;row.0.styledef.case.1.comparison.isrowcase=true&lt;/P&gt;&lt;P&gt;row.0.styledef.case.1.comparison.leftmethod=percentComplete&lt;/P&gt;&lt;P&gt;row.0.styledef.case.1.comparison.lefttext=percentComplete&lt;/P&gt;&lt;P&gt;row.0.styledef.case.1.comparison.operator=eq&lt;/P&gt;&lt;P&gt;row.0.styledef.case.1.comparison.operatortype=double&lt;/P&gt;&lt;P&gt;row.0.styledef.case.1.comparison.righttext=100&lt;/P&gt;&lt;P&gt;row.0.styledef.case.1.comparison.trueproperty.0.name=bgcolor&lt;/P&gt;&lt;P&gt;row.0.styledef.case.1.comparison.trueproperty.0.value=eac6c9&lt;/P&gt;&lt;P&gt;row.0.styledef.case.1.comparison.truetext=&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Hope that helps!&lt;/P&gt;</description>
      <pubDate>Thu, 28 Jan 2021 23:33:18 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469548#M2692</guid>
      <dc:creator>SarahNa</dc:creator>
      <dc:date>2021-01-28T23:33:18Z</dc:date>
    </item>
    <item>
      <title>Re: Conditionally Highlighting on Column Values in a View</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469549#M2693</link>
      <description>&lt;P&gt;Thanks Sarah; well done!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Nick, I expect Sarah's example will do the trick, but if you still need a hand, just let me know.&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, 29 Jan 2021 03:26:48 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469549#M2693</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2021-01-29T03:26:48Z</dc:date>
    </item>
    <item>
      <title>Re: Conditionally Highlighting on Column Values in a View</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469550#M2694</link>
      <description>&lt;P&gt;Hi Sarah!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Hope you are well.  Thanks for the workaround.  Nice creative thinking.&lt;/P&gt;&lt;P&gt;I'll see if this is something our teams can work with.&lt;/P&gt;</description>
      <pubDate>Fri, 29 Jan 2021 13:41:25 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/conditionally-highlighting-on-column-values-in-a-view/m-p/469550#M2694</guid>
      <dc:creator>NickVa1</dc:creator>
      <dc:date>2021-01-29T13:41:25Z</dc:date>
    </item>
  </channel>
</rss>

