Notion Formulas 2.0: Counting Database Entries with Filter() and Length()

The length() and filter() Notion formula functions are game changing! Learn how to count Notion database entries using Notion's brand new formulas in this video.

I explore three ways to filter and count database entries using basic project and task database examples.

Notion Formula 2.0 Help Links:

Notion Helpful Links:

[rspeckham]

Really useful! I have been trying to filter by status for ages but was using “contains” rather than ==

[Sisko]

Such excellent and timely and thoughtful and well organized information. I’m learning so much from you. Please keep doing what you’re doing. It’s amazing.

[JacquiB]

This was so helpful, thanks! Now I was able to implement the filter formula in a couple of places in my Notion workspace to get more 'automation' done.

[heathertully]

exactly what I was looking for! thank you

[GiovannaRibeiro]

You just saved my databases, thank you so much!!! This is exactly what I was looking for.

[hudsonsantos]

OMG, THANK YOU SO MUCH!!! You saved me

[ArchistryYT]

This doesn't seem to work when trying to filter in a "Multi Select" property. Do you have a method to count total number of entries with a particular multi-select tag?

[lifebykaye]

This is amazing! Thanks for making it easy to understand! ✨Do you also have an example for counting overdue dates? (e.g. counting tasks that are past due date/overdue?)

[SSSSS_]

This is what I was looking for, thank you so much for this! Also, is it possible to count how many unique values there are in a number property?

[MortenSahlMadsen]

I simply LOVE YOU, dear stranger! It have made me make very advanced formulas with NO coding exp.

One questions: How do i make a filter work on a date range? So e.g., filter tasks that is only within a specific date range (a date property with a start and end date). I have been trying this for ages!

My latest try was something like this, but it only works if the dates are exactly the same start and end date:

== dateRange(prop("Contract period"), prop("Contract period (1)")))

[hot_dammn]

Amazing. Thank you for this. Do you know if you can combine 2 filters within the one formula? Say you had 4 different status and want to count 2 of them. Or count if checkbox and a status is selected

[StrijdTegenHaaruitval]

thank you so much for this! however, something is really strange, when I use the formula to count the number of tasks, it returns 18 to me, while I have 16 in my database. What is happening there?

edit: figured it out, it counted my templates as well. Thanks again for this!

[olegbril]

how to make that zero (0) is not visible in count field when there is no items?

[LorealMendoza]

Great video! I've been struggling with these formulas and now I think I can do the most basic stuff. How would you approach something like this: I have two databases called Invoice and Totals. I want Totals to show three data: (1) The total amount from Invoice that have the OVERDUE status, (2) SENT status, and (3) PAID status. I've only made it work to get the total of ALL the data using relation, not according to status. 😶

[kitsunelofibeats]

Bro, I hope you can help me. I want make a formula it counting evertime when i open the note. It's possible?

[andersonaf]

Hi, I'm trying to find a way to have a total SUM for Main Item and sub-itens. Do you know some way? Thank You so much

[BigBoss-gbcx]

For every new entry, how do you connect the two database automatically?

[dariustrainer]

I have a unique situation where I have a database of terms. The name property (1st column) is a a random word/concept. When clicked it opens into a page of text blocks that define the word or concept. The remaining columns in that database are dates and such.

I have a second database that is meant to allow for journaling. Each entry (name property) is a day of journaling. The properties in that database are several tags, and a relation to the first database I mentioned. There is also a roll up that allows multiple selections from the first databases name property.

Is there a way to get a count of how many times a name property from the first database is selected in the second database?

I’m sure that was wildly confusing but I’m having so much trouble finding anyone who can help.

[BabuOfficial]

How do I total two Databases' SUM?