Filtering

[Mike Guilbault]

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.

[Brendan]

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 2 years, 8 months ago by Brendan.

Attachments:

You must be logged in to view attached files.

[Author]

Posts