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:
TABLE 1: TOPIC
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.
TABLE 2: ARTICLES
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.
