Multi Box with a condition

[Nourrahmcnean]

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.

[Or · Accepted solution]

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.

[Nourrahmcnean]

Thank you for the explanation