Filter Question

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?

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:

2 Likes