Expand my Community achievements bar.

How to highlight Actual Hours in Red

Avatar

Community Advisor

Here's a sweet textmode you can use on a column in a Task view to highlight the Actual Hours in Red once they exceed the Planned Hours, drawing attention to the "ehm...are we there yet?" conversation.

@NRYN R - inactive‚ I invite you to add this to your wfpro.com textmode library at your convenience.

Regards,

Doug

displayname=

linkedname=direct

namekey=actualworkrequired

querysort=actualWork

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.leftmethod=actualWork

styledef.case.0.comparison.lefttext=actualWork

styledef.case.0.comparison.operator=gt

styledef.case.0.comparison.operatortype=double

styledef.case.0.comparison.rightmethod=work

styledef.case.0.comparison.righttext=work

styledef.case.0.comparison.trueproperty.0.name=bgcolor

styledef.case.0.comparison.trueproperty.0.value=eac6c9

styledef.case.0.comparison.truetext=

textmode=true

valuefield=actualWorkRequired

valueformat=compound

viewalias=actualworkrequired

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

6 Replies

Avatar

Community Advisor

...and here's how to do the same thing from the originating Issue, assuming it was converted to a Task:

aggregator.displayformat=minutesAsHoursString

aggregator.function=SUM

aggregator.namekey=view.relatedcolumn

aggregator.namekeyargkey.0=resolveTask

aggregator.namekeyargkey.1=actualworkrequired

aggregator.valuefield=resolveTask:actualWorkRequired

aggregator.valueformat=compound

displayname=Actual Hours

linkedname=resolveTask

namekey=view.relatedcolumn

namekeyargkey.0=resolveTask

namekeyargkey.1=actualworkrequired

querysort=resolveTask:actualWork

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.leftmethod=resolveTask:actualWork

styledef.case.0.comparison.lefttext=resolveTask:actualWork

styledef.case.0.comparison.operator=gt

styledef.case.0.comparison.operatortype=double

styledef.case.0.comparison.rightmethod=resolveTask:work

styledef.case.0.comparison.righttext=resolveTask:work

styledef.case.0.comparison.trueproperty.0.name=bgcolor

styledef.case.0.comparison.trueproperty.0.value=eac6c9

styledef.case.0.comparison.truetext=

textmode=true

valuefield=resolveTask:actualWorkRequired

valueformat=compound

viewalias=resolveTask:actualworkrequired

Avatar

Community Advisor

...annnnnnd finally, again from an Issue view, here's how to alias the resolve Task's Planned Hours as "Revised Hours" and highlight them in yellow if they exceed the originating Task's "original" planned hours. For example, an Issue might have been raised with an 8 hour estimate, converted to a Task that now shows 12 "revised" planned hours (in yellow, since they exceed the 8), and 14 actual hours (in red, since they exceed the 12).

True story, sadly. But pretty cool visuals that I think will help better manage such situations, going forward.

Regards,

Doug

aggregator.displayformat=doubleAsInt

aggregator.function=SUM

aggregator.namekey=view.relatedcolumn

aggregator.namekeyargkey.0=resolveTask

aggregator.namekeyargkey.1=work

aggregator.valuefield=workRequired

aggregator.valueformat=doubleAsInt

displayname=Revised Hours

linkedname=resolveTask

namekey=view.relatedcolumn

namekeyargkey.0=resolveTask

namekeyargkey.1=work

querysort=resolveTask:work

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.leftmethod=resolveTask:work

styledef.case.0.comparison.lefttext=resolveTask:work

styledef.case.0.comparison.operator=gt

styledef.case.0.comparison.operatortype=double

styledef.case.0.comparison.rightmethod=work

styledef.case.0.comparison.righttext=work

styledef.case.0.comparison.trueproperty.0.name=bgcolor

styledef.case.0.comparison.trueproperty.0.value=feecc8

styledef.case.0.comparison.truetext=

textmode=true

valuefield=resolveTask:work

valueformat=doubleAsInt

Avatar

Level 10

Super thanks to @Doug Den Hoed‚ and @NRYN R - inactive‚ for sharing these text codes.

Have a great day!

Mvh

Kundan.

Avatar

Level 4

Hi There! I'm trying to get this to work for percentComplete & a custom field, "Budget % Complete" but it's just bringing over the "percentComplete" field/date vs bringing the custom field and formatting.. What I'm doing wrong must be simple, but any edits result in nothing to populate. Any ideas?

displayname=

linkedname=direct

namekey=percentComplete

querysort=Budget % Complete

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.leftmethod=Budget % Complete

styledef.case.0.comparison.lefttext=Budget % Complete

styledef.case.0.comparison.operator=gt

styledef.case.0.comparison.operatortype=double

styledef.case.0.comparison.rightmethod=percentComplete

styledef.case.0.comparison.righttext=percentComplete

styledef.case.0.comparison.trueproperty.0.name=bgcolor

styledef.case.0.comparison.trueproperty.0.value=eac6c9

styledef.case.0.comparison.truetext=

textmode=true

valuefield=percentComplete

valueformat=doubleAsPercent

viewalias=percentComplete

Avatar

Level 4

Clearly, I needed to slow down. Got it! Thanks for the posts guys