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

[@jaysonbrady6831]

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

[@yeskevz]

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

[@NotionWorkflow]

Thank you!! Probably has alot to do with video/audio quality tbh

[@neilugaddan]

Thank you! This is the exact problem and solution I need!

[@NotionWorkflow]

Awesome! 😁👌

[@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.

[@meometmot]

By the way, how should I change the formula if I want to sum up entries of a particular month, not the current month?

[@NotionWorkflow]

Thank you!! That is awesome to hear 😁 Here is an example for January i.redd.it/ogpj8ucvtd4c1.png?app_web_view=android

[@meometmot]

@@NotionWorkflow Thank you so much. Looking forward to more useful content and tutorials from you :)

[@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! 😄

[@NotionWorkflow]

Thank you!! 🙏

[@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.

[@jaysonbrady6831]

A workaround for this is using automations to automatically add the related page

[@cchurchlead]

@@jaysonbrady6831how would you do that? I’m having that same issue now where I am trying to automatically have a relation page with a MMMM YYYY format added to a task that has the a date that matches for a date property

[@putuwiraangriyasa731]

Finally I found the method, thank you

[@NotionWorkflow]

You're welcome! 😁👋

[@leticiarezende1]

Amazing!

[@EntrainementhandballFr]

Very useful as usual ! Thank you again

[@beatrizorganizer]

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

[@NotionWorkflow]

You're very welcome 😁

[@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?

[@NotionWorkflow]

You'd do something like this where year(date) == 2023. Here is a more recent video illustrating different date periods. kzbin.info/www/bejne/b6bCeX-Zj7meh7c

[@MariaLuiza-oq7le]

Thank you SO much!

[@NotionWorkflow]

You're very welcome 😁

[@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. map(Appointments.filter(month(current.Date) == 6),month(now())),current.Session).sum()

[@NotionWorkflow]

You'd need to remove the "month(now())" portion of the formula since you're just specifying 6 for June. This video should also be able to help you out kzbin.info/www/bejne/b6bCeX-Zj7meh7c

[@Talik13]

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!

[@NotionWorkflow]

Thank you for your feedback!

[@Talik13]

@@NotionWorkflow thank YOU for the tutorial!

[@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 ?

[@NotionWorkflow]

Thank you! I appreciate your comment :) Not a dumb question at all! You can just subtract one from now() to reference the previous month. Previous Month: month(now())-1 Full Formula: map(prop("Entries").filter(month(current.prop("Date")) == (month(now()))-1),current.prop("Number")).sum()

[@orbisvideo]

​@@NotionWorkflow thank you very much ! a bit long but works perfectly now --> if(prop("Name")=="Taxes",map(prop("Transactions").filter(month(current.prop("Date")) == month(now())-1).filter(year(current.prop("Date")) == year(now())),current.prop("IMPÔT")).sum(),map(prop("Transactions").filter(month(current.prop("Date")) == month(now())).filter(year(current.prop("Date")) == year(now())),current.prop("IMPÔT")).sum())

[@frescobaldi4393]

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!

[@NotionWorkflow]

Great question! You can do something like this. i.redd.it/ogpj8ucvtd4c1.png?

[@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.

[@NotionWorkflow]

I don't have a formula where you can change the date range of each month, but I did create another example for someone else where you can specify a date range to only add up entries in that specified date range. You could iterate on it where you only add up entries specific only to the day, as opposed to the month and day. Here is a template where you could get started: www.notion.so/rayclark/StartDate-EndDate-2298361d6fa84558ae8d9f0c1f812faf?pvs=4 You could use the date() function to extract the day of the month in your case.

[@trushinshine]

Thanks for this, but there is no option to duplicate so I can't access formula's@@NotionWorkflow

[@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

[@NotionWorkflow]

Great question! Someone else asked for something similar and you could probably use a date range to responsively configure for what you're looking for. You can specify a range and see if a date is within the start and end date of that range. If it is, you can sum the total. Here's an example. rayclark.notion.site/StartDate-EndDate-2298361d6fa84558ae8d9f0c1f812faf

[@yeskevz]

@@NotionWorkflowI still can't get it to work XD I don't get how your sample formula would work.

[@NotionWorkflow]

Ok I simplified what I created so you can sum data between two dates - independently in each database entry. Obviously it can be improved, but it will definitely help you get started. I nested two formulas so that you can sum everything up through a relation. Best of luck creating your own formula! www.notion.so/rayclark/StartDate-EndDate-2298361d6fa84558ae8d9f0c1f812faf?pvs=4

[@yeskevz]

@@NotionWorkflow I think I'm starting to get it. Thank you so much! Will try more formulas, hope it works!

[@ancebumbule4750]

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.

[@NotionWorkflow]

Here is a way where you can specify the month via a number property and responsively add up your related entries based on what you write into the "month" property. You can do this with year as well in another formula property and through another number property that specifies year. I think I'll be coming out with another video on this given the number of comments I get on this exact video. rayclark.notion.site/Calculating-Entries-Specific-to-A-Month-6a8ffd5fa68045ef94c2f6be5419dc0a?pvs=4

[@ancebumbule4750]

​Thanks! This is also a reasonable way, but I came up with another solution, that I think, might be more user-friendly and already account for years, so no need to create another property. I created a date property in Calc database and then adjusted the formula like this: map(prop("Entries").filter(month(current.prop("Date")) == month(prop("Date"))),current.prop("Number")).sum() Now all I have to do is change the date to any date in a month of which I want to see the calculated sum.

[@NotionWorkflow]

You're welcome!

[@RoadToUbermensch]

@@NotionWorkflow If i have a databases called "Week", can't i filter it by the date is between the beginning and end of the week ? Thank for you work, it's great

[@NotionWorkflow]

@RoadToUbermensch Yes you could do that through advanced filtering to take into account both a start and end date. I also made another video showing dates between a specified date through a database property here ➡️ kzbin.info/www/bejne/l4TIaXZ9prOEb6M

[@mizanrahman_07]

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

[@NotionWorkflow]

You could create another formula property that filters the date based on current year in the related database and then map the total based on that new property instead. Like this: rayclark.notion.site/Calculating-Entries-Specific-to-A-Date-in-Notion-35b75d85fb7f4b4c901e617ebeb3a566?pvs=4

[@mizanrahman_07]

@@NotionWorkflow Thank a lot bro, it's very helpful it works, but, at first, i cannot change the number to currency. after i delete the last argumen in your ifs formula, it can. i change it to become like this.. ifs(year(prop("Date")) == year(now()),prop("Number")) however, i haven't understand the logic behind it. could you explain to me? again, thanks a lot bro

[@mizanrahman_07]

@@NotionWorkflow oh yeah, also, how if i want exact day in this year, this month, and this week? because, it's same like current month. it's current day, but same day in another week, month, and year, will also appear. (edit) i have tried it. my solution is make "formula property about amount if year is now" in the related database. after that, i make "formula property about amount if week is now", but i retrieve the data from "formula property about amount if year is now." and then, i map the total based on the last "formula property about amount if week is now" and i filter it with current day what do you think? is the solution correct? and if correct, is there solution that is more efficient? thanks

[@NotionWorkflow]

You'd use the year(), week(), day() formulas and the "and" formula to combine exact dates.

[@NotionWorkflow]

It's just a nested formula so that you can do the filtering in the main database and then map the sum of it in the related database for exact filtering without having to condense into one formula property.

[@tropicaally]

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

[@NotionWorkflow]

I sure do! Check this video out: kzbin.info/www/bejne/gKmvg2acl7llmtk

[@totesmcpreesh7617]

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?

[@NotionWorkflow]

You can't add or change another property. You can use the dateEnd or dateStart formula to choose which side of the range you want to compare to.

[@rickdee888]

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?

[@NotionWorkflow]

You could adjust the column width and/or configure the property to Wrap or not. You'll need to create a new entry otherwise if you want it as another database entry line.

[@rickdee888]

@@NotionWorkflow. Thanks for your reply. FYI. If I set it to warp, when I make the column wider, they will try to go in a single row. If I set it to non-wrap, then they will display in a single row no matter how wide the column is. It is just not doing what I wanted. Anyway, looks like there is no proper way out. Thanks.