Skip to main content

Hello and thank you for considering to help me!

Every day, my Airtable is supplied with additional lines through an x ​​bias.

How can I create a view that only collects last week's rows?

I only manage to get the lines from 7 days ago and not all those from last week.

Any idea ? 🙂

Kindly

Hi @Julien_Etoke ,
For example, this formula determines which week the date is compared to today.

SWITCH(WEEKNUM(TODAY())-WEEKNUM({Date}),
1,"Last Week",
0,"This Week",
-1,"Next Week"
)

If you filter this field to show only last week, then that view will always show only last week's records.

When a week begins on Monday, it is like this.

SWITCH(WEEKNUM(TODAY(), "Monday")-WEEKNUM({Start Date}, "Monday"),
1,"Last Week",
0,"This Week",
-1,"Next Week"
)

 

Hi @Julien_Etoke ,
For example, this formula determines which week the date is compared to today.

SWITCH(WEEKNUM(TODAY())-WEEKNUM({Date}),
1,"Last Week",
0,"This Week",
-1,"Next Week"
)

If you filter this field to show only last week, then that view will always show only last week's records.

When a week begins on Monday, it is like this.

SWITCH(WEEKNUM(TODAY(), "Monday")-WEEKNUM({Start Date}, "Monday"),
1,"Last Week",
0,"This Week",
-1,"Next Week"
)

 


Thanks a lot, you are a machine !

Reply


Terms & Conditions