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.
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
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
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.
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
@Anthony Imgrund‚ How did you learn to do this? This is fantastic
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Views
Likes
Replies