Create a view for sharepoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-2383103%22%20slang%3D%22en-US%22%3ECreate%20a%20view%20for%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2383103%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20been%20having%20trouble%20getting%20the%20desired%20view%20created%20for%20my%20specific%20scenario.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20period%20start%20column%20and%20a%20period%20end%20column.%26nbsp%3B%20These%20periods%20can%20be%20of%20varying%20length%2C%20spanning%20a%20few%20days%20to%20several%20weeks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20SharePoint%20list%20I%20want%20to%20create%20a%20view%20which%20shows%20specifically%20the%20items%20that%20have%20a%20period%20start%20and%20end%20which%20is%20included%20in%20any%20part%20of%20the%20previous%20week.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20created%20the%20logic%20in%20excel%20to%20do%20this%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-visual%22%3E%3CCODE%3EIF(AND(PE%26gt%3B%3D(TODAY()-(7%2B(WEEKDAY(TODAY()%2C3)))%2CPS%26lt%3B%3D(TODAY()-((WEEKDAY(TODAY()%2C3))%2B1)))%2C%22T%22%2C%22F%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPE%20%3D%20Period%20End%20and%20PS%20%3D%20Period%20Start%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I'm%20struggling%20with%20is%20how%20to%20recreate%20this%20in%20a%20SharePoint%20list%20view%20as%20I%20understand%20that%20the%20view%20filter%20logic%20cant%20contain%20'weekend'%20and%20a%20calculated%20column%20cant%20contain%20%5Btoday%5D.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20plan%20was%20to%20create%20additional%20calculated%20column%20for%20Pervious%20week%20start%20and%20end%20dates%20based%20on%20todays%20date%20and%20then%20use%20them%20somehow%20to%20filter%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20received%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%408341BD79091AF36AA2A09063B554B5CD%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2383103%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi,

I have been having trouble getting the desired view created for my specific scenario.

 

I have a period start column and a period end column.  These periods can be of varying length, spanning a few days to several weeks.

 

In my SharePoint list I want to create a view which shows specifically the items that have a period start and end which is included in any part of the previous week.

 

I've created the logic in excel to do this 

 

IF(AND(PE>=(TODAY()-(7+(WEEKDAY(TODAY(),3))),PS<=(TODAY()-((WEEKDAY(TODAY(),3))+1))),"T","F")

 

PE = Period End and PS = Period Start

 

What I'm struggling with is how to recreate this in a SharePoint list view as I understand that the view filter logic cant contain 'weekend' and a calculated column cant contain [today].

 

My plan was to create additional calculated column for Pervious week start and end dates based on todays date and then use them somehow to filter on.

 

Any help would be greatly received :smile:

 

0 Replies