Is there a way to use 2 criteria in a column display rule? | Community
Skip to main content
Tracy_Parmeter
Level 3
February 14, 2023
Solved

Is there a way to use 2 criteria in a column display rule?

  • February 14, 2023
  • 1 reply
  • 574 views

I have a proof approval report that shows all proofs still awaiting a decision. I want to add a column rule for proofs that had no deadline set but were created more than 15 days ago. Is there any way in text mode to use both of these criteria? 

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

Hi, you can add more than 1 column rule in a report, they work from top down. You can use these for the 2 criteria you're after, and color one of them. If this doesn't work just try reversing the order of them, I sometimes have to mess with the order of rules I need to work together. This is a screenshot of the rules added (you can only add 1 rule at a time - when you're doing with the first one, you do same thing to add a second one but you just may have to reverse the rule order based on your results).

 

1 reply

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity AdvisorAccepted solution
Community Advisor
February 14, 2023

Hi, you can add more than 1 column rule in a report, they work from top down. You can use these for the 2 criteria you're after, and color one of them. If this doesn't work just try reversing the order of them, I sometimes have to mess with the order of rules I need to work together. This is a screenshot of the rules added (you can only add 1 rule at a time - when you're doing with the first one, you do same thing to add a second one but you just may have to reverse the rule order based on your results).

 

If this helped you, please mark correct to help others : )