Task view custom column to show red when 'Default Baseline Task >> Planned Hours' < 'Planned Hours'

[EricSa7]

Hi smart people,

Within a task view, I am hoping there is a way to show the field 'Default Baseline Task >> Planned Hours' as red when it is less than the 'Planned Hours'.

Any help would be great. 

[Kurt_Jones]

EricSa7, this is somewhat a complicated ask but is doable.  This link, https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/compare-field... shows how you can use the Advance Options area of reporting to setup a rule for the conditional formatting then switching to textmode to incorporate the other date field for comparison.

[EricSa7]

Hi Kurt,

Thanks for taking the time to reply. The link takes me to a page that says 

Unsupported characters in path  

 I note that you say it is for reporting in your comment. Will this same logic work in Task View? I was just going to look and see if I could apply the same logic from reporting to task, but given that I cannot access the link, I thought I would ask. 

Cheers, 

[Kurt_Jones]

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/compare-field...

Looks like it picked up a comma at the end.

[EricSa7]

I think I have done all that the instructions asked. I added the line in red and this is the code I needed up with, but no formatting is being applied. Can you see any reason why?

linkedname=defaultBaselineTask
namekey=view.relatedcolumn
namekeyargkey.0=defaultBaselineTask
namekeyargkey.1=workrequired
querysort=defaultBaselineTask:workRequired
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.isrowcase=false
styledef.case.0.comparison.leftmethod=defaultBaselineTask:work
styledef.case.0.comparison.lefttext=defaultBaselineTask:work
styledef.case.0.comparison.operator=ne
styledef.case.0.comparison.operatortype=double
styledef.case.0.comparison.rightmethod=workRequired
styledef.case.0.comparison.righttext=workRequired
styledef.case.0.comparison.trueproperty.0.name=textcolor
styledef.case.0.comparison.trueproperty.0.value=FFFFFF
styledef.case.0.comparison.trueproperty.1.name=bgcolor
styledef.case.0.comparison.trueproperty.1.value=FF0000
valuefield=defaultBaselineTask:workRequired
valueformat=compound
viewalias=defaultBaselineTask:workrequired

[EricSa7]

Sorry, I should add, that I ended up going with 'Not Equal To', hence the line 'styledef.case.0.comparison.operator=ne'

[Kurt_Jones]

EricSa7,

styledef.case.0.comparison.leftmethod=defaultBaselineTask:workRequired
styledef.case.0.comparison.lefttext=defaultBaselineTask:workRequired

I'm not sure that will make much of a difference.  I tried this in my environment and my baseline and planned hours always matched so nothing was changing.  I changed workRequired to be actualWorkRequired so that I could log time against a couple of tasks and complete them to see if the formatting is working; in that case it did format the whole column since planned hrs had a number and in many cases New tasks still had 0 actual hours so they weren't equal and it made the cell red.  Here's what it looked like, I brought in the planned hrs, actual hrs, and the default baseline fields so I could see what was in them.