Dynamic Filter on multi select field, And not Or
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
------------------------------
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
------------------------------
