Clay Icon

Issue with Filter Settings: AND and OR Configuration Problem

ยท
ยท

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?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    ๐Ÿ‘‹ 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!

  • Avatar of Muhammad S.
    Muhammad S.
    ยท
    ยท

    You will need to work with Filter groups

  • Avatar of Simon R.
    Simon R.
    ยท
    ยท

    "Validated Work E-Mail" already is a filter group

  • Avatar of Muhammad S.
    Muhammad S.
    ยท
    ยท
  • Avatar of Muhammad S.
    Muhammad S.
    ยท
    ยท
  • Avatar of Arturo O.
    Arturo O.
    ยท
    ยท

    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

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    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!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Simon R.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: