Use conditional formatting in a text-mode field

[ibmfur]

Hi

I have a project-level report. In this report, I have a text mode field that basically shows at which task this project is currently stuck on.

What I'd like to do is color code the row based on this field, so if it reads "Blocked," I want the entire row to be highlighted.

The tricky part is that this field does not really exist in the data schema so I was wondering how the syntax would look like?

I've been browsing through some relevant posts like How to set display rules in text mode - Adobe Experience League Community - 488385 and Comparing dates (and more!) with conditional forma... - Adobe Experience League Community - 518262

but I'm still unsure about how to achieve this.

Any insights would be greatly appreciated. Thanks in advance.

[KellieGardner · Accepted solution]

@ibmfur - If the text mode in your report is a valueexpression you won't be able to use native conditional formatting for that column

What you could do is look at other columns available to see how you could leverage those to color code the row. Example if the project condition is at risk or behind you could change the color of the whole row. 

[ibmfur]

It's useful to know the native conditional formatting is not supported if the valueexpression is in use.

I will look into other ways to do the color coding using the other fields as you suggested.

Thank you!

[KellieGardner]

@ibmfur -  Since the value expression data isn't stored data for Workfront to reference to format your field is really what it comes down to. Another option to consider is using a calculated field on your objects vs a calculated column. Then workfront will store that data and can use it for formatting. If using a another field on the object to format isn't an option then you could try this way instead. 

[KavyaSi1]

@KellieGardner - Hi, I'm actually trying to do what you've suggested, or at least I think I am.

I've created a Task Status calculated column in TextMode to have conditions on date ranges and is set to string values I want.

Now, the Due date column is the one I want to highlight, based on the value of the Task Status column.

I've tried some of the resources like Calculated custom fields vs. calculated columns | Adobe Workfront, Text mode syntax overview | Adobe Workfront ,etc for referencing.

If I'm trying to use this new column's value in another column's valueexpression or for the rightmethod in formatting, how do I put it?

Apologies if I'm missing something obvious, still pretty new to this.

Thanks

[KellieGardner]

@KavyaSi1 - you can not use the data from a text mode column in conditional formatting- to color itself or any other field. Since the textmode data isn't stored (it's calculated each time the report is run) there is not a reference point for the formatting. The recommendation is to use a calculated field on the object if you want to use it in conditional formatting.