I need a little help with a formula.
Basically I’m sending data to Airtable that contains text separated by commas, and I need to check if a specific column contains a part of that text that I’m sending.
I’m currently using Zapier with the Find function, but I’m having problems because it’s trying to find the complete string of text in the table and not considering the commas.
In short, I want to know if this record in my column contains a part of the full text that I am sending.
Here’s a simple graphic to explain: