Help

Is there logical operator "includes any of"?

Topic Labels: Formulas
Solved
Jump to Solution
3987 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Pjero_Kusijanov
7 - App Architect
7 - App Architect

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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