If you’re looking for the word “data” somewhere in a field, why not remove “the” from the FIND()
formula and look only for “data”? That way you’ll pick up anywhere where that word occurs, regardless of what else might be in the string.
FIND("data",LOWER(Name))
Having said that, FIND()
on its own will return where in the string the found word starts. So if the string read “the data”, this formula on its own will return “5” (ie. where in the string the word “data” starts).
You could combine this instead with IF()
to return something else. For example:
IF(FIND("data",LOWER(Label)),"Match")
This would instead return the word “Match” in the formula field if it finds the word “data”.