Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey, I want to exclude Z from in the list of the multibox and show only Items from Type E
I added this expression =if( not Match (Item,'Z') AND Match(Type,"E"), Item)
But it prints an empty list.
You've got the wrong quotes around the 'E', but otherwise that should work. Keep in mind that using this multibox will apply selections to both the Item and Type field at the same time, not just the item, e.g. selecting 'X' will select Item = X, Type = E.
You've got the wrong quotes around the 'E', but otherwise that should work. Keep in mind that using this multibox will apply selections to both the Item and Type field at the same time, not just the item, e.g. selecting 'X' will select Item = X, Type = E.
Thank you for the explanation