I have a column name Keyword1 in one table, which contains a single word in each row and a Title column in another table. I want to highlight the Title if it contains any word from the column Keyword1.
For that, I used CONTAINS() function, but it seems like it does not work with a list of words and the second parameter of the formula should be a text.
How can we find if a string contains a substring from a list or column?
Solved! Go to Solution.
Could you try
ISNOTBLANK(INTERSECT(SPLIT([Title], " "), Keyword[Keyword1]))
User | Count |
---|---|
16 | |
6 | |
6 | |
3 | |
2 |