This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Attaching workflow below. I'm trying to filter using the Contains formula. After spending lots of time going over the syntax and case sensitivity options again and again, I tried to isolate the problem in the below workflow, by manually inputting the same word in 3 different ways, one of the three was copy pasted from my original data (the one that isn't matching).
Can someone explain why it isn't matching? I don't want to have to copy paste it into my formula just to make it work. I need to first understand why it isn't matching so that I can include logic in my workflow that will match no matter what. I know the cheap solution is to use "OR" 2 times, but for the sake of the puzzle, what's the difference between Custodian and Custodian? How do you diagnose this? The only thing I can suspect is maybe the "o" character for some reason was written in a different language (still looks identical but counts as a different character?)