22

I want to create a view whereby it does not include any items where the 'next review date' are not blank. In other words, only include items which have this field populated.

How can I filter my view for this blank criterion in SharePoint? It does seem to recognized [] or [blank] or "" in the criteria box.

Improve this question
2
  • Thank you .. this solution work great!! Thank you form the bottom of my heart! – user21753 Jan 6 '14 at 14:30
  • This does not work with multiple lines of text. – George Saavedra Nov 18 '19 at 16:09
27

Create a list view and set the filter; where date time column is not empty (see below)

enter image description here

Improve this answer
2
  • does this work for lookup columns? – egidiocs Apr 3 '16 at 6:34
  • @egidiocs yes it did work for lookup columns – Nickson Yap Nov 11 '20 at 10:06
2

the view's filter will be: 'next review date' in not equal to [leave it blank - don't write anything]

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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