Hello,

I’m trying to create a filterByFormula that finds a certain value in an array.

Here is an example. I have this array:

Using filterByFormula I want to get the values that have exactly the word Azure. So in this case it should get only the first Azure, not Azure Cloud.

I tried to use FIND OR SEARCH but this 2 return both these values.

Some kind of workaround I found doing the formula like this:

AND(OR(FIND('Azure,', ARRAYJOIN(Skills,','))))

So I’m converting the array into a string and then search for Azure,. Yes, that is a comma

This way I’m able to select the Azure value.

But as you can see in the example above I also have Python and (the brown one). If I use the above method I only get the first Python even thought I should get the second one too. This one is weird. I’m not sure why this is happening to be honest.