conditional formatting question

Peggy · 03/27/23

Hi,

I have a conditional format setup to look at a specific product line and GEO when it does not contain specific geo's then apply a grey format to 2 fields, so that people know that nothing is required in those fields.

The specific product line was not met and the GEO did include the 1 of the specific geo's.

Isn't the first field the primary requirement?

unfortunately the 2 fields did not go grey.

Thanks for any help/suggestions.

Jeff Reisman · 03/28/23

@Peggy Could you share some screenshots of the fields/data involved and the conditional formatting rules?

Peggy · 03/28/23

conditional formating.png

see attached. Thank you!

Jeff Reisman · 03/28/23

@Peggy Having a second condition in the formatting rule is an AND condition, meaning that both criteria must be true for the conditions to be met and the rule applied.

If you want to have the Product Line condition overrule the GEO condition, just make one rule for Product Line and a separate rule for GEO, and make sure the Product Line rule is above the GEO rule in the list of Conditional Formatting.

In my example below, only rows where both conditions are met get the formatting:

If I change that to have two rule with different conditions, resulting in the same formatting:

Peggy · 03/28/23

Hi Jeff, I deleted my rules and tried your approach, this did not work becasue we have other product lines that are within the GEO. I appeciate the input.

I will change the smartsheet and have the user manually enter in N/A when applicable.

appreciate your time on this!!

Jeff Reisman · 03/28/23

https://community.smartsheet.com/discussion/comment/369248#Comment_369248

LOL I wish I knew what that meant, but oh well! Good luck!

conditional formatting question

Answers

Categories