Share via

Sharepoint view filter to NOT Include a word

Audi86 756 Reputation points
Jun 14, 2022, 10:08 PM

Hi,

we have a site which has over 1000 site pages and content team needs to create a personalized view to filter the required pages. We have pages names starting with "news-XXXXXXXX". Is there any way to filter out the News-pages through view filter.

211438-image.png

thanks

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,059 questions
0 comments No comments
{count} votes

Accepted answer
  1. QuentinB 91 Reputation points
    Jun 15, 2022, 3:46 PM

    Hi @Audi86 ,

    To do this, I would try to filter out all the Pages containing "News" in the Title. (Method 1)
    Warning: this will also filter out all the colums named "XXX-news-XXX"
    I'll propose an alternative method if that is a problem. (Method 2)

    Here are the steps for Method 1:

    Create a calculated column "is_News" which value is "Yes" if the column "Name" contains "News" using the following formula: =ISNUMBER(FIND("News",[Title]))

    211762-image.png

    Then filter out all the pages where the value of column " is_New" equals "Yes" ("Is not equal to" is a native filter.

    Method 2
    With this method you only filter out pages which Title starts with "News"

    Steps:

    Create a calculated column that returns the first 4 characters of the value of the column Title using: =LEFT([Title],LEN([Title])-4)
    211700-image.png

    Then again you can filter out the Pages where the the value of the calculated column equals "News"

    Please let me know if that's not helping.
    Best regards,

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Jinwei Li-MSFT 4,736 Reputation points Microsoft Vendor
    Jun 15, 2022, 7:11 AM

    Hi @Audi86 ,

    May be you could try to create a new column to filter the news page.

    1.Create a calculate column
    211566-image.png

    2.Pin to filters pane.
    211577-image.png

    3.You could filter to include a word.
    211586-image.png
    211527-image.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.