Conditional OR command

Haskellf · 11/10/15

Is there a Conditional OR command anywhere. I see an "AND" but no "OR". So strange that I cant find OR since its part of any regular expressions and saves time.

Christine Oakes · 11/10/15

Yes, there is an Or statement in Smartsheet.

=IF(OR([Value 1]41 = "High", [Value 2]41 = "High"), "Treat as High", "Treat as Normal")

Haskellf · 11/10/15

Thanks Christine. Can I use this in the "Conditional Formatting" to change color of a cell?

Christine Oakes · 11/10/15

Sorry - misunderstood your question. Are you trying to have an Or for entries in one column or different columns?

Haskellf · 11/10/15

I'm trying to write a Conditional Formatting to change the bg color of the cell when one of the following is Checked.

i.e.

If Final is Checked or Working is Checked then apply this format to the entire row.

Currently, I can only find "AND" as one of the conditions.

Haskellf · 11/10/15

Bob Andrews · 11/10/15

There are a couple options for this...

1. Create two conditional formatting rules - one for each condition.

2. Add a checkbox column to your sheet with a formula that will check the box if your OR conditions are met (Christine's formula). Then set your conditional formatting rule based on the checkbox column.

Welcome to the Smartsheet Forum Archives

Conditional OR command

Comments

Categories