Filter By Week

Hello, I have a tab called Events and I was wondering if it was possible to filter it by weeks. I want it to only show events in the current week. Help would be much appreciated. Thank You

1 Like

Do you want to list upcoming events in the next 7 days (rolling)?
Or do you want to show events from the week even if the days are in the past?

The right solution will depend on what you want to show.

If to be done from Google Sheets,

image

Formula in C2: =ARRAYFORMULA(if(A2:A<>"",weeknum(B2:B,1),""))

Formula in D2: =ARRAYFORMULA(if(A2:A<>"",if(weeknum(today(),1)=weeknum(B2:B,1),TRUE,FALSE),""))

So in Glide, display what Show=TRUE

Now, getting this done from GDE, you need to calculate Week-number using math column and then compare it with today’s date - longer trip in my opinion.

3 Likes

I want to list upcoming events in the next 7 days (rolling)

Create an additional column in your Google Sheet which spits out TODAY()+7 using an array formula.
In the Builder, filter for events where the event date is less than TODAY()+7.

2 Likes