Question

I have a "Preferred" checkbox that I would like to write a formula to automatically check if the "Client" column contains one of multiple values such as "Spatco" or "Guardian."

I keep getting "Incorrect" or "Unparseable"

IF(OR([Client]@row = "Spatco"), ([Client]@row = "Guardian"), 1, 0)

Thank you in advance for the help!

Paul Newcome · Accepted Answer

Your parenthesis are off. You don't need the ones in the middle of the OR function.

You have

OR(this), (that)

You should have

OR(this, that)

Monique Odom Stearn · Accepted Answer

Hello @lcain,

Is the Client column multiselect, or does it have spaces before or after the words? My suggestion would be to try a formula that uses contains instead of equals. Try the following:

=IF(OR(CONTAINS("Spatco",[Client]@row),CONTAINS("Guardian",[Client]@row)), 1, 0)

Itai Perez · Accepted Answer

Hey @lcain

I think the only issue is excess ().

Try this: IF(OR([Client]@row = "Spatco", [Client]@row = "Guardian"), 1, 0)

It worked for me when I tested it.

Always follow the colors of the brackets, it will help you notice if you closed your formula too early.

If you have a column with more than one word in the name then you use Square[] brackets.

Hope that helps