IF with OR logical argument

Topic Labels: Formulas
789 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


1 Reply 1

Hi @Paul_Cardenas

Looking at your screenshot, you’ve got the dreaded “formatted” quotes issue. The quotes (single or double) in formulas need to be plain text, not formatted text, so this:

IF(OR(Status = "Todo"), "blah")

instead of this:

IF(OR(Status = “Todo”), “blah”)

Edit the formula, retyping the quotes in the formula field and it should come good. It can also help to use a text editor to compose your formulas as they generally use plain text.