Help

The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.

Trying to filter with "AND" and "OR" in a Gallery

Topic Labels: Views
1196 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Lance_Clack
4 - Data Explorer
4 - Data Explorer

I have a gallery and I added a filter with two condition, so if column one has a specific value or column two has a specific value. That works fine, but now I want to also only show records within the past week that match either of those conditions but it doesn’t seem to let me use a date filter combined with an “OR” condition. It will let me do date AND column one, but after that it only lets me add more “AND” conditions. Is this just not possible? Is there another way to do this?

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Lance_Clack!

You would have to create a formula field that combines your AND and OR statements, and then you would filter on that formula field.

Okay, that works, thank you!