Hi, I'm trying to filter a lookup by multiple values (E.g. where the year column is 2016 or 2017) but nothing i can think of seems to work. I've tried putting 'fn-Or("2017","2016")' in the filter value box but it's not working. Filtering by a single value is fine but otherwise i can't build any kind of logic into it.
Thanks for any help.
Solved! Go to Solution.
Thanks for the answer, perhaps you can help me with another list lookup filtering question.
I am able to set a list lookup A to be filtered by named control list lookup B, however if i try to set A to be filtered by a named control calculated value C where the formula is simply B, the filter doesn't work. Why is that and is there a way to fix it?