1 of 1 people found this helpful
Contains() should get you what you need.
Thanks - do you have an example of how I can write this calculation?
if contains(lower([Search Term]),"bag") then "Bag" end
I would use lower() as well so you don't have to search for all possibilities of Bag, bag, BAG
You rock - thanks!