Set up correct function (IF, CONTAINS)

Hi, community.

I need some help)

Here is example. I need function that works like that:

1) take text from List

2) compare to Main

3) if text in Main have on of the word from List, return "yes"

Thanks all😊


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!