Expand my Community achievements bar.

SOLVED

Custom Rules in Report Views

Avatar

Level 8

I would like to display the field 'Resolve Project:Name' in a green cell only when the name of the converted project is different than the name of original request.

Help? Is there any way to do custom rules? I don't see an option for text mode.

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi - this was a fun challenge :)

Here you go

valuefield=resolveProject:name

querysort=resolveProject:name

valueformat=HTML

displayname=Resolve Project

linkedname=resolveProject

namekey=view.relatedcolumn

namekeyargkey.0=resolveProject

namekeyargkey.1=name

styledef.case.0.comparison.leftmethod=resolveProject:name

styledef.case.0.comparison.lefttext=resolveProject:name

styledef.case.0.comparison.rightmethod=name

styledef.case.0.comparison.righttext=name

styledef.case.0.comparison.operator=notin

styledef.case.0.comparison.operatortype=string

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.truetext=

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

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

styledef.case.0.comparison.trueproperty.1.name=textcolor

styledef.case.0.comparison.trueproperty.1.value=000000

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

styledef.case.0.comparison.trueproperty.2.value=def6e2

View solution in original post

4 Replies

Avatar

Level 3

Hi Samantha,

Could use the 'Reference Number' fields (vs. names) to compare the differences between the two numbers. If they are different then color the cell green.

Avatar

Correct answer by
Level 10

Hi - this was a fun challenge :)

Here you go

valuefield=resolveProject:name

querysort=resolveProject:name

valueformat=HTML

displayname=Resolve Project

linkedname=resolveProject

namekey=view.relatedcolumn

namekeyargkey.0=resolveProject

namekeyargkey.1=name

styledef.case.0.comparison.leftmethod=resolveProject:name

styledef.case.0.comparison.lefttext=resolveProject:name

styledef.case.0.comparison.rightmethod=name

styledef.case.0.comparison.righttext=name

styledef.case.0.comparison.operator=notin

styledef.case.0.comparison.operatortype=string

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.truetext=

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

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

styledef.case.0.comparison.trueproperty.1.name=textcolor

styledef.case.0.comparison.trueproperty.1.value=000000

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

styledef.case.0.comparison.trueproperty.2.value=def6e2

Avatar

Level 8

@Anthony Imgrund‚ How did you learn to do this? This is fantastic

Avatar

Level 10

Well, I have a view that compares Actual Completion date to Planned Completion date and I just adjusted it. Not sure where I initially learned but I'm sure it was from someone here on the community site or from a Leap presentation a few years ago. :)

Best part of being a Workfront client, everyone is so forthcoming with help and sharing