Filter Question

[Jon_Marchand]

I am trying to create a filter that will allow me to filter the data and show all matches regardless of whether or not the first field is selected. Currently, when my first field (Sessions) is not selected the formula will not filter the data say when a day of the week is selected (my second column). It will still show all results. How can I change my expression to filter the data regardless of what fields are selected?

[Marc_Dillon]

It looks like you’re doing what you should be doing for this with the OR( ISBLANK()...)

I would suspect that maybe the CONTAINS() isn’t what you should be using. Can you provide more info?

Is the table name really “Edscape…”, or is that an extra ‘d’ in there?

Check out my sample app here for something very similar:

Sample App: Multiple (and optional) dependent dropdown filters Tips & Tricks 💡

I created a sample app to demonstrate setting up multiple search filters to narrow down the possibilities in a final Ref-type column. “Multi Filter Example” here: https://www.appsheet.com/portfolio/546920 This app does NOT utilize Appsheet’s implicit dependent dropdown feature, as described in the following post. The reason for this is to allow the user the option to filter by any, or all, or none, of the 4 filters, independently. Whereas the implicit dependent dropdown will auto-hide the …