Check if a field contains at least one item of an array

Topic Labels: Formulas
564 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi all, is it possible to have a formula that searches if a text field contains at least one item of an array?
Specifically, I would like to achieve the following:

I define topic names and related keywords for each one manually in table #1:

Name (string) | Keywords (Multi-select) 

Animals | dog, cat, elephant,
Fruits | apple, banana, orange
Colors | red, blue, yellow

I have some articles in another table and I want to update the Topic field by checking if the article title contains items of the array field from table 1.

Title (string) | Topic (Lookup) (this should be the field updated by the formula)

The dog is sleeping | Animals
The apple is red | Colors, Fruits

I know I can use a formula and manually define keywords combining IF, AND, OR, FIND etc.

However, topics and keywords frequently change, so I should update the formula every time a new topic enters the table.
Instead, I want a formula that searches if any item of an array (Keywords field) is contained in the Title field.

I really appreciate any help you can provide.

0 Replies 0