Expand my Community achievements bar.

Check out the upcoming December events for Workfront System Administrators!

How do you do conditional formatting based on more than one condition using two different columns?

Avatar

Level 2
Level 2

I would like to set up conditional formatting where: 

The task planned completion date column is less than today, and the % complete column is less than 100%.

I haven't been able to figure out how to do it.  Can it be done, and if so, can anyone help with instructions?

3 Replies

Avatar

Level 5

Hi @bfg - Unfortunately, the conditional formatting in Workfront only allows for one condition to be entered. Might be worth looking through the Ideas page and upvoting a similar topic, or if it doesn't exist adding it in. Dual condition reporting would definitely be beneficial!

Avatar

Level 7

i would say this is doable and you can apply as many conditions as you need. However, this requires creating a custom field on a given object where you would actually set the logic for formatting.

If needed I can share more details

Avatar

Level 2
Level 2

Thank you for the comments.  I'm trying to do this without a custom field.  This is pretty basic stuff and I should be able to do something like this without a custom field (at least in my personal opinion).  I can live without it, but if this can't be done without custom fields, I would just like it to be considered as a future enhancement.