Task view custom column to show red when 'Default Baseline Task >> Planned Hours' < 'Planned Hours' | Community
Skip to main content
E
EricSa7
December 17, 2024
Question

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

  • December 17, 2024
  • 2 replies
  • 846 views

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. 

2 replies

Kurt_Jones
Community Advisor
Kurt_JonesCommunity Advisor
Community Advisor
December 18, 2024

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-fields-conditional-formatting, 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.

E
EricSa7Author
December 18, 2024

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
Community Advisor
Kurt_JonesCommunity Advisor
Community Advisor
December 19, 2024

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,

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.

 

 

kautuk_sahni
Community Manager
kautuk_sahniCommunity Manager
Community Manager
September 1, 2025

@ericsa7 just checking in! Were you able to get this resolved? If one of the replies above helped—whether it completely solved the issue or simply pointed you in the right direction—marking it as accepted can make it much easier for others with the same question to find a solution. And if you found a different way to fix it, sharing your approach would be a great contribution to the community. Your follow-up not only helps close the loop but also ensures others benefit from your experience. Thanks so much for being part of the conversation!

Kautuk Sahni
Terms & ConditionsAccessibility statement

Loading footer...