formula checkbox referencing contact field problem

Hills Cruz

I am a newbie trying to check a formula checkbox if one of two names or both names are in a contact field list. Why isn't this working?

=IF(CONTAINS("Name1", contact@row), OR(CONTAINS("Name2", contact@row), 1, 0))

Paul Newcome

Think of the OR function as the "logical statement" portion of the IF and both of the CONTAINS functions are "logical statements" of the OR.

OR(CONTAINS(..........), CONTAINS(..........))

=IF(OR(...........................), 1, 0)

=IF(OR(CONTAINS(..........), CONTAINS(..........)), 1, 0)

Paul Newcome

Think of the OR function as the "logical statement" portion of the IF and both of the CONTAINS functions are "logical statements" of the OR.

OR(CONTAINS(..........), CONTAINS(..........))

=IF(OR(...........................), 1, 0)

=IF(OR(CONTAINS(..........), CONTAINS(..........)), 1, 0)

Hills Cruz

Thanks so much, Paul!

Paul Newcome

Happy to help. 👍️