Help

Re: Multiple conditions in Formula not working

442 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Nicolas-Paul_AL
4 - Data Explorer
4 - Data Explorer

Hi,

I want to do a select on my records according two conditions :

  • Find in “Resource title” field a text
  • Find in “Format” field an exact text

For both conditions, I want them to be case nonsensitive because some text are written in caps, other not.
So, at the moment, I’ve this :

filterByFormula=AND(FIND("some text",{Resource title}),(FIND("Video",{Format}")))

And I’m getting the INVALID_FILTER_BY_FORMULA error message .
So, what I’m doing wrong ? Is it possible to have the nonsensitive case research ?

Thanks.

1 Reply 1
gwynn_kruger
6 - Interface Innovator
6 - Interface Innovator

Try this for a case-insensitive search:
AND(FIND(“some text”,LOWER({Resource Title})),(FIND(“video”,LOWER({Format}))))

This may be why you were getting the error:
image