SP 2013
Use case- To pull all the relevant items for a weekly (every Wednesday) meeting from one place, in this case hopefully a list view to go to view this.
Hi guys, I’m hoping to tackle something that I keep hearing about but I sure as heck can’t get this to work. We have a list with a field called “submitted date” we need to be able to see a list view of items with submitted date from last Wednesday to next Wednesday..so today(11/19) we should see items with submitted date anywhere from 11/12 to 11/19..and tomorrow(11/20), we should see items from (11/19 to 11/26). I spoke to a couple of your in the chat forum which helped me a little bit but unfortunately didn’t have time to follow up and thought this might be better medium to ask that.
In any case, this is specifically where I’m stuck- Any reference to [Today] in calculated columns is going to be inaccurate unless there are item updates. So using something like [Today]- Weekday[Today]+3 for last Wednesday (or another one for next Wednesday)Â as helpful as it is will not be dynamic. So…. what gives? Should I try JavaScript instead? Little bit lost. Is there a SPD hack for this may be?
Appreciate any input.
Thank You!
Samir
update #3:Â
Turns out part of the problem was in the calculated column. after that it seems to work as expected.
It should be-
Calculated column: StartWednesday =IF(WEEKDAY[Submitted Date])<4, [Submitted Date]-WEEKDAY[Submitted Date])-3, [Submitted Date]-WEEKDAY[Submitted Date])+4)
Calculated column: EndWednesday =IF(WEEKDAY[Submitted Date])<4, [Submitted Date]-WEEKDAY[Submitted Date])+4, [Submitted Date]-WEEKDAY[Submitted Date])+11)
#update 2: I guess what I’m trying to do really boils down to being able to do have list view filter logic like this
(Condition 1 and Condition 2) OR (Condition 3 and Condition 4)
Is there a way to do this? If so, that’d solve this.
Update #1: I managed to get a little further by doing this but still not complete. Appreciate any help.
Calculated column: StartWednesday =IF(WEEKDAY[Submitted Date])<5, [Submitted Date]-WEEKDAY[Submitted Date])-3, [Submitted Date]-WEEKDAY[Submitted Date])+4)
Calculated column: EndWednesday =IF(WEEKDAY[Submitted Date])<5, [Submitted Date]-WEEKDAY[Submitted Date])+4, [Submitted Date]-WEEKDAY[Submitted Date])+11)
Then create a list view that filters with this rule-
StartWednesday < [Today]
AND
EndWednesday > [Today]
Now it shows relevant stuff EXCEPT for one item. It doesn’t show item from Wednesday itself. Today I’ll see all relevant items except for the one from 11/19. To address this I tried creating another calculated column that identifies any Wednesday entries and flags it but I can’t, for the love of buddha, find a way to merge this in the filter logic (above). Thoughts?
Ahh…rereading that again. I see what you’re asking. You’re right, my solution wouldn’t work. Sorry about that.
Thanks for the response, Shawn. If I’m understanding you correctly, here’s what I’ll see today from that formula I think
Submitted date from 11/12 to 11/22 right?
In our case, we’d like to see last wed to this (11/12-11/19) and say on 11/20, we’d like to see 11/19-11/26
