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.
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.