Custom Rules in Report Views

[SamanthaIsin]

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.

[joes68374352]

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.

[AnthonyIm · Accepted solution]

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

[SamanthaIsin]

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

[AnthonyIm]

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