Notion Answers

Get help from other Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

How to set filter to only show current week?

Hello again,

I am working on my Meal Planning Database and have a linked view on my dashboard that I want to only show the current weeks meals.
I have searched the filters, but I could only find "due today or within a week from now" but that shows next weeks meals.
It would not bother me if I could see the weekdays, but having it like this right now confuses me when it comes to planning grocery lists.

Thank you,
Sue

1 Answer

0vote

polle Points22890

Create a new column called Week and set is as a formula.

Add this Notion formula:

formatDate(prop("Date"), "W") == formatDate(now(), "W")

Change "Date" to the name your property for dates has.

With this, the week property will show checkboxes and will automatically check the ones that are from the current week.

This way you can add a filter where week is checked and done.

Hope this helps.

Please log in or register to answer this question.

Exclusive for Notion Answers Users

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect