Using AND/OR Statements for multiple criteria searches not working.
I’m having issues doing multiple criteria searches using AND OR statements.
For example, I’m trying to filter all the Conduit folder by dimensions less than 1-1/4” and I want to show all items with a description that contains both EMT and FMC.
I can’t seem to get this to work. I’ve copied my search formula. What am I doing wrong?
The first Or for EMT works fine, but adding another Or or AND statements messes it up. I've tried this countless other ways but can't get it to work.