Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Is there an "OR" condition in conditional formatting?
I'm a very new user (1 week) and I am trying to apply conditional formatting if any one of 4 conditions is met. I need an OR statement but can't figure out how to do it, other than to do a separate rule for each condition. I searched the community and help and couldn't find anything about OR conditions.
Thanks!
Comments
-
Hello Megret,
Conditional Formatting doesn't currently have an OR option (only the AND option). To accomplish this, you'll need to create four separate rules—one for each of your conditions. You can duplicate a rule by right-clicking on it.
More on conditional formatting can be found in our Help Center: https://help.smartsheet.com/articles/516359-conditional-formatting
-
Hi,
Is there a OR function implementation on the horizon?
I have 6 columns of which all six can have a possibility of 6 statuses and need 6 colors per status. Writing 36 conditional rules will be very time consuming.
Where an OR function will be so much better to use.
Please let me know.
-
Yovanka - have you gotten a resolution to this? We're trying to use an OR function now with conditional formatting and having no luck.
