Notion Formulas 2.0: Adding Up Database Entries By Month Using Date Properties

Learn how to add up your monthly entries in this Notion Formulas 2.0 tutorial!

You'll use the map formula to add up a number property based on entries filtered for the current month.

Notion Helpful Links:

[meometmot]

Thank you so much for the useful and easy to follow tutorials. I've been putting off learning Notion formulas for weeks watching other tutorials but you made it so easy for beginners to pick up.

[jaysonbrady]

This video solved a problem I’ve been trying to figure out for days

[JoelsonVianaFilms]

Wowww Thank u man...
I searched for a long time for an answer to solve my monthly bills in my Template and now I finally found it. Congratulations on the content and thank you very much! 😄

[yeskevz]

Why the heck the videos in this channel doesn't have that much views? They're so useful

[EntrainementhandballFr]

Very useful as usual ! Thank you again

[erikwitkowski]

This is great! The only annoying part is having to set relationships for every entry in the database to a record in the calc database.

[orbisvideo]

First, great video, clearly the best channel to really dig into notion potential.
It's maybe a dumb question but how to do the exact same filter but to display numbers from the previous month m-1 ?

[beatrizorganizer]

I love you so freaking much, you don't even know. Thank you so much!!!!

[putuwiraangriyasa]

Finally I found the method, thank you

[Talik]

I like this, but at 720p max, I literally cannot see the punctuation marks that you're typing. I'm not super familiar with how Notion's formula syntax so this was actually kind of hard to follow. I was able to get most of it, but often I couldn't figure out if you were using spaces, periods, commas, or what. But overall a very nice tutorial!

[beatrizorganizer]

How do I sum numbers of a specific year? I know I have to replace the "month()" function with the "year()" function. But what do I put inside "year()" function, let's say, if I want to calculate the number from 2023? year("2023") doesn't work, right?

[runionbryan]

Thanks for the video. I tried the formula you used (with the modification of using a specific month), but it keeps giving me an error with the .sum() Can you help?

It works with out adding a month and with out the sum to show an array.

== 6), month(now())), current.Session).sum()

[frescobaldi]

Is it possible to modify the formula so that it applies to one specific month instead of the current one? Filter in one column October 2023, in other November 2023, December 2023, January 2024, etc.? Thank you for the tutorial!

[trushinshine]

Do you have any videos showing how to create formula to change the date range of each month. Trying to have budget where income and expenses are calculated from pay date to day before next pay date. For example, Pay date 26th Feb - 25th March would be February. Pay date 26th. March - 25th April would be March etc. I would like this to be formula based, rather than having to filter the view on dashboard. Do you have any ideas? I'm new to notion so would appreciate some assistance. Thanks in advance.

[ancebumbule]

This is very cool, but is there a way to filter month to month without changing the formula? Let's say I have an overview of my total expenses and total income and I want to switch between previous months and this month, see the total of the year, etc. This formula would give me the current month and if I wanted to see the previous one, I would have to go into the formula and change it. I'm stuck.

[mizanrahman_]

Thanks for the explanation, very useful

I have tried it, but it has problem. It is current month, but same month in last year will also appear. for example, current month Feb 24, but Feb 23 also appear.

How's the solution? Thanks

[yeskevz]

What if I want to get the sum of data in between two dates? Like getting the amount from the 1st quarter? I tried dateBetween but I think my format inside the bracket () is wrong

[tropicaally]

do you have a video explaining how to create a formula based on time spent on a task?

[totesmcpreesh]

So if I had 1 entry with a start date and an end date could I make it fetch data from another entry and all those date ranges and add specific data from another column?

[rickdee]

If I drag your "Entried" column in your "Calc' database to much wider, will your "Example1, "Example2" and "Example3" still in separate lines or it will start to get wrap into a single line? Is there a way to make sure they stay at separate line rather than get wrap up?