Hi,

Looking to use the FIND function for a column and return a result in Zapier.

My column ‘Name’ contains an entry **'Data’**

I want to return a result, even when a partial match exists for **'the data’**

I’ve got `FIND("the data", LOWER({Name}) & "")`

but this returns nothing.

Is there something along the lines of an ‘If Contains’ formula that I can apply to Zapier via an Airtable formula?

I appreciate that this might mean entries with “the” would be considered e.g. ‘the number’ but thought there must be a way to find the closest match?