When using a multi select field for one of your dynamic filters, it essentially uses an 'Or' function. So, if my field is Colors, and I have 'Red,Orange, Yellow, Green, Blue', and in my dynamic filter I choose both Red and Orange, it will show me all records that have Red OR Orange Selected.
Is there some sneaky way to make QB treat this like an And function (presumably with some creative formula field)? So if I select Red, Orange in my dynamic filter, it only shows the records that have Red AND Orange selected?
------------------------------
Michael Tamoush
------------------------------
Question
Dynamic Filter on multi select field, And not Or
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.