I’m trying to create a
filterByFormula that finds a certain value in an array.
Here is an example. I have this array:
filterByFormula I want to get the values that have exactly the word
Azure. So in this case it should get only the first
I tried to use
SEARCH but this 2 return both these values.
Some kind of workaround I found doing the formula like this:
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
But as you can see in the example above I also have
[emptyspace] Python (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.
Is there a function to find a specific value in the array ? Not using