Forum Discussion
Solved
If statement with multiple search words
I've tried creating this with the conditional column but there seems to be a bug when analyzing my text. In my "Other" output, text is showing up than contains the word "funding" so it should be the ...
Well I found a work around. I created a duplicate column and it works!!
SGLake to be honest, not really lol :) but it possibly has something to do with the format of the data. Have you tried doing a format trim and clean of the data first?
Unfortunately yes, I've trimmed and cleansed the column.
SGLake the only way to figure it out really is to share it i am afraid
Well I found a work around. I created a duplicate column and it works!!