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

Harry N Nomikos 1,186 Reputation points
2022-07-05T11:24:01.71+00:00

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?

217656-image.png

Any help here will be greatly appreciated

Cheers
Harry

SharePoint
SharePoint
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
    2022-07-06T08:40:32.153+00:00

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

    218088-image.png

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

    218101-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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Harry N Nomikos 1,186 Reputation points
    2022-07-08T07:03:08.937+00:00

    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.

    218810-image.png

    Your help here would be greatly appreciated
    Cheers
    Harry

    0 comments No comments