Skip to main content
Question

Dynamic Filter on multi select field, And not Or

  • September 7, 2021
  • 0 replies
  • 61 views

Forum|alt.badge.img+14
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
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
You can type red AND orange with AND in UPPER case in the search box ......

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------