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
Solved
Lines of the last week
+5Best answer by Sho
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"
)
+5Hi @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 !
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.