Hi,

We've been using the same formulas as Steve suggests, except we'll put each "Find" condition into a separate calculated column (and then hide them). And we would have the same PickSeqMatch calculated column, as a summation of the various find conditions of each calculated column, which as Steve notes easily indicates when there are matches.

We'll further use the row formats feature based upon the value of the each condition, to then colour the row so that you know what condition was validate for the "or" condition, in this situation a different colour for each picksequence match. So you can tell at a glance on your view what picking sequence is applicable for that item.

We do this in many of our exceptions analysis gridviews in Inventory, order Entry, Purchase Orders, and Job Costing. Works really well, and you get to be Martha Stewart for a day.

Best,
Brian