Forum Discussion

MichaelTamoush's avatar
Qrew Captain
3 years ago

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

1 Reply

  • You can type red AND orange with AND in UPPER case in the search box ......

    Mark Shnier (YQC)