Show all list items that are going live in the next 7 days

Harry N Nomikos 1,186 Reputation points

Hi Team

I want to create a view in a SP list that will show all tasks going live in the next 7 days.

I want this to calculate from today and to pull all list items that going live in the next 7 days.

I'm not sure if I need to create a calculated column first or my formula in the filter option is wrong?


Any help here will be greatly appreciated


A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,211 questions
{count} votes

Accepted answer
  1. Yi Lu_MSFT 17,366 Reputation points

    Hi @Harry N Nomikos
    You could filter the list view like this:


    As a result, you could get the view you want:


    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Harry N Nomikos 1,186 Reputation points

    Hi @Yi Lu_MSFT

    I've tried to create a view to only show when the Change Status is equal to the below conditions and when the entry has been modified within the last 7 days from today.

    0 Triage in progress

    1. New
    2. Scoping & Planning
    3. Deployment & Implementation
    4. Hypercare & Adoption
    5. Backlog

    The problem is, it's picking up other Change Status's that I don't wont to include such as "Completed" and "No Impact" in the SP List view.


    Your help here would be greatly appreciated

    0 comments No comments