Multiple conditions in Formula not working

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.

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

1 Like

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.