Limit a list box selection and then when selected, remove some items from another field
Hi,
I am trying to write a list box expression to limit the items in the Line of business list box to one item 'ABC' and then when its selected select 'ABD' less products 'A'.
My example is below which I place in list box expression.
=if(LineOfBusiness = 'ABC',Select (LineOFBusiness='ABC' less Product 'A'),null())
Please explain with raw data which can help us to think?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful