Automated Checkbox is column contains one of multiple values

lcain

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

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

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

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

Paul Newcome

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

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

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