Filtering

Viewing 1 reply thread
  • Author
    Posts
  • March 7, 2023 at 3:20 PM #49102

    Mike Guilbault
    Participant

    I’m trying to create a filtered list where a date field is empty and select certain companies. I’ve attached a photo of the filter I tried, but it doesn’t work. Instead of ANY or ALL, I need an AND as in ANY of the Company Names AND Completed is empty.

    Any ideas on how to accomplish this?

    Attachments:
    You must be logged in to view attached files.
    March 7, 2023 at 4:54 PM #49105

    Brendan
    Keymaster

    Hi Mike,

    There’s a couple ways you can do that. If you put OR in between the company names in one field you’ll get that. E.g. Apple OR Netflix OR TapZapp.

    Or if you hold down the option key you can click the ... button that appears on the right and that’ll add a new All/Any selector. So now you can have the Anys for the Company Names and the overall selector set to All. Like my screenshot attached.

    • This reply was modified 1 year, 8 months ago by Brendan.
    Attachments:
    You must be logged in to view attached files.
Viewing 1 reply thread

You must be logged in to reply to this topic.