conditional formatting question
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.
Answers
-
@Peggy Could you share some screenshots of the fields/data involved and the conditional formatting rules?
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
see attached. Thank you!
-
@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:
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
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!!
-
LOL I wish I knew what that meant, but oh well! Good luck!
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives