0

I need to filter out items that have empty 'multiple lines of text' columns in my list view. Traditional filter methods do not work. See images below. Please help!

enter image description here

enter image description here

1

It's by design that the 'multiple lines of text' columns only can be filtered using 'Contains' and 'begins with'.

As a workaround, I recommend you use SharePoint Designer to edit the list view, then use Filter in the List View Tools options to filter items when multiple lines of text column is null.

enter image description here

Reference: SharePoint Designer 2013 – How to modify List View web part filters and parameters

0

Yes, you couldn't apply equals/not equals filtering for the "multiple line of text" column in the view.

You can try the above SharePoint Designer solution (or) alternatively you can make that column a mandatory one to prevent empty comments.

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.