Hi, In the user setting, I've set up an enum...

[Simon_Chow]

Hi,

In the user setting, I’ve set up an enum list with multiple options that users can chose from, let’s say it’s a country list with (US,Canada, UK) there as an option. And there’s a security filter: [country]=USERSETTINGS(country). But then when people select (US,UK) in the setting, it returns those rows with country that contains both US AND UK at the same time instead of displaying the rows which contains either US OR UK as i intentionally designed. Would there be any solution to this?

Thanks in advance!

Best,

[Aleksi_Alkio]

You should type IN([country],USERSETTINGS(country)).

[Simon_Chow]

Thanks again Aleksi, you’ve been super helpful!

[Aleksi_Alkio]

You’re welcome