Expand my Community achievements bar.

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 6

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.