For some reason I can't change the filter settings to "AND" at the first two filters and "OR" at the least filter. When I change one filter f.e. to "AND", it always automatically changes the other filters set to "AND" as well. Is this a bug or am I doing something wrong?
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
You will need to work with Filter groups
"Validated Work E-Mail" already is a filter group
Hey Simon, thanks for the inquiry! Muhammad got it right here, the way filters would be setup to achieve a mix of tasks would be best with groups, which you can then combine as AND/OR by doing that. However, I often find it more efficient to setup formula columns that track multiple variables and output a specific range of values to filter by. Here's a video of what we call Super filters, hope it helps -https://www.loom.com/share/c81034190c954983b4d303110bd92339
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!