Conditional OR command

Haskellf

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

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

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

Christine Oakes

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

 

Haskellf

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

Bob Andrews

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.