How do you do conditional formatting based on more than one condition using two different columns? | Community
Skip to main content
B
BarryGr
New Participant
November 8, 2023
Question

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

  • November 8, 2023
  • 2 replies
  • 1360 views

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?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    Rafal_Bainie
    Rafal_Bainie
    New Participant
    November 10, 2023

    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

      B
      BarryGrAuthor
      New Participant
      November 10, 2023

      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.

      VicSellers
      VicSellers
      New Participant
      November 8, 2023

      Hi @barrygr - 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!

        Terms & ConditionsAccessibility statement

        Loading footer...