2

I'm trying to set up a way of filtering one of my list views and struggling a bit.

enter image description here

The first 3 filters are working fine to show the entries with only a date of today or later but when I use the final 'Or' filter to include blanks, it removes the other required criteria.

3 Answers 3

0

Set view filter as following picture shows. enter image description here

6
  • Thanks Emily, unfortunately as I have other filters too, the 'Or' option will remove those required ones. Is there another way around it to keep all the other filtered criteria? Aug 4, 2021 at 10:05
  • Please provide other filters to further troubleshooting. Aug 4, 2021 at 10:08
  • Thanks Emily, I've just updated my initial comment. Aug 4, 2021 at 10:13
  • I have updated the answer, please check. Aug 5, 2021 at 6:01
  • Thank you so much Emily, that works perfectly! Aug 5, 2021 at 11:18
0

Add list view filter on view settings page like this:

enter image description here

For 2nd Or filter, keep the value as blank (do not enter anything in the textbox).

Output:

enter image description here

3
  • Thank you for your help. Unfortunately, as I have a couple of other filters, when I add the one you've suggested, it's using the 'Or' to remove the other filters if that makes sense? Aug 4, 2021 at 10:01
  • Can you show us what are other filters you have in list view? Try adding other filters first & then date filters at last....Like <filter 1 > AND <filter 2> AND <Date filter 1> OR <Date filter 2>. Aug 4, 2021 at 10:04
  • Hi Ganesh, I've updated the screenshot to show all of the required filters. The 'Or' option for blanks is then removing those required ones. Aug 4, 2021 at 10:09
0

You can set Date column filter like below in view:

enter image description here

2
  • Thank you for your help. Unfortunately, as I have a couple of other filters, when I add the one you've suggested, it's using the 'Or' to remove the other filters if that makes sense? Aug 4, 2021 at 10:01
  • First you add all your required queries and then add these date filters at the end. Aug 4, 2021 at 10:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.