Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Lines of the last week

Topic Labels: Formulas
Solved
Jump to Solution
1730 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Julien_Etoke
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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"
)

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

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 !