Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Field Comparisons

Avatar

Level 10
Hey folks, I've been trying to get field comparisons to work and so far they don't. What am I doing wrong? :) Here's one where I'm comparing the task planned completion date to the default baseline task planned completion date. If the two are not equal, make the text red. The textmode for the column view below translates into standard mode and the dropdowns are how I want them to be. It's just not coloring the text red. linkedname=direct namekey=plannedCompletionDate querysort=plannedCompletionDate styledef.case.0.comparison.icon=false styledef.case.0.comparison.leftmethod=plannedCompletionDate styledef.case.0.comparison.lefttext=plannedCompletionDate styledef.case.0.comparison.operator=ne styledef.case.0.comparison.operatortype=date styledef.case.0.comparison.righttext=FIELD:defaultBaselineTask:plannedCompletionDate styledef.case.0.comparison.trueproperty.0.name=textcolor styledef.case.0.comparison.trueproperty.0.value=d30519 styledef.case.0.comparison.trueproperty.1.name=bgcolor styledef.case.0.comparison.trueproperty.1.value=ffffff styledef.case.0.comparison.truetext= textmode=false valuefield=plannedCompletionDate valueformat=atDate -skye
Topics

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

1 Reply

Avatar

Level 10
nevermind, forgot the rightmethod line!! styledef.case.0.comparison.rightmethod=defaultBaselineTask:plannedCompletionDate -skye