Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Is there logical operator "includes any of"?

Topic Labels: Formulas
Solved
Jump to Solution
772 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, is there a way to compare strings that include same word(or part of the word), but not the whole phrase?

1 Solution

Accepted Solutions

You can use the FIND or SEARCH functions to see if a word is in a phrase. Combine it with the OR and IF functions to get “includes any of”.

IF(
  OR(
    FIND("keyword 1", {field to search}),
    FIND("keyword 2", {field to search}),
    FIND("keyword 3", {field to search})
  ),
  "Found at least one",
  "Didn't find any"
)

If your {field to search} is a lookup field, you will need to turn it into a string: {field to search} & ""

You do have to be careful if some of your keywords are subsets of each other. For example, if you have keywords “alpha” and “alphabet”, this simply formula will find “alpha” even if the field includes only “alphabet”.

See Solution in Thread

2 Replies 2

You can use the FIND or SEARCH functions to see if a word is in a phrase. Combine it with the OR and IF functions to get “includes any of”.

IF(
  OR(
    FIND("keyword 1", {field to search}),
    FIND("keyword 2", {field to search}),
    FIND("keyword 3", {field to search})
  ),
  "Found at least one",
  "Didn't find any"
)

If your {field to search} is a lookup field, you will need to turn it into a string: {field to search} & ""

You do have to be careful if some of your keywords are subsets of each other. For example, if you have keywords “alpha” and “alphabet”, this simply formula will find “alpha” even if the field includes only “alphabet”.

Wonderfull, I manage to make it work :slightly_smiling_face: Thanks