And(Or Expression

[D_harrier]

Looking for some help, I’ve seen a couple that are close on here, but have been unable to find the exact fix.

I am using a security filter on a set of survey forms.

What I want to show, is all surveys that have been completed within the past 7 days, along with a user list ‘admin’ who can see all surveys by all users.

For the user/admin list I am using (which works well) a lookup table for all user’s email for each Location:

or(useremail() = “admin1Test@test.com”,
useremail() = “admin2test@test.com”,
IN([Location], SELECT(FTE[Location], [Email] = USEREMAIL())))

Additionally, the filter for days works well. ([Time] >=now()-7)

Its probably super obvious, but how would I best combine these two to create a time filter for the 7 days, then apply the user filter as well?

Thanks for the help!

[Suvrutt_Gurjar · Accepted solution]

You could please try

AND( OR(useremail() = “admin1Test@test.com”,
useremail() = “admin2test@test.com”,
IN([Location], SELECT(FTE[Location], [Email] = USEREMAIL()))), [Time] >=now()-7)

[D_harrier]

This worked perfectly, thank you!