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?
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!
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
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.
Views
Replies
Total Likes
Hi Rafal,
I'm looking to achieve something similar and was wondering if you would kindly be able to share how this would be achieved with a custom field?
Kind Regards,
Joshua.
sure Joshua,
so basically we have a calculated custom field called "indicator"
with formula:
IF(({status}="NEW")=true && {DE:NLT}>$$NOW,"blank",IF((({status}="INP" || {status}="BES")=true &&{DE:NLT}<$$NOW),"Green","red"))
I than use column conditional formatting in a very simple way:
if "indicator" is Green >> do this
if "indicator" is red >> do this
Hope this makes sense
cheers!
Rafal
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies