Made me smile when I saw your thumbnail pop up. Immediately switched over from the other video as I know yours will likely be more comprehensive and easier to understand 😅
Thanks so much for this video. I was pulling my hair out with the "prop" terminology and beginning to cry as I couldn't even add two numbers together in two different columns. THANK YOU so very very much. Seem like every other youtube video hasn't flagged this new formula terminology. Automatic subscription. Big thanks.
So helpful, I love the update ! Little trick that maybe you know, you can reduce the YYYYMMDD into an L or l, for the formatDate function, to know if prop("date") == Today
Nice video and really happy to have the new list functions. Now we just need reduce() added to go with map() - unless you know of a hacky way to get that already.
I asked for that too during the beta, lol! I'm sure there's a hacky way. I'd love to solve for it. Feel free to link me to a description (or post here) of an outcome you're trying to achieve and I'll see if I can hack it!
Great video, very clear. all that I needed. however, I'm wondering if you can create a notion formula generator and/or an online converter to/from Notion formula. I'm trying to find something like that without success s ofar
Love how clear your video is, at beginning could I have prop or name field like you did ,,so add name then add total income minus total expenses and have it calculate based on that name field, I tried and tried different methods. I need different totals for two different rows
@benjaminborowski appreciate your reply. What I ended up doing was just kept the other account separate instead of together. Because I'm new to this, I'm not sure how to rephrase, but will try. One row has bank 1 income bank 2 income bank 1 expenses bank 2 expenses...those are names on top. Then on side is bank 1...next line is bank 2. Maybe those are rows top is columns. Then I was trying to do formula based on bank name, then income less expenses...but it didn't work..it works without the name
In the next month or so. I don't have a fixed date yet and I had a death in the family so I'm moving a little slower than I usually do. Sign up for the list and I'll keep you posted!
This new feature of using rollup through a formula will be very helpful to prevent large databases from freezing. Currently, I use a database with over 50 properties that are just rollups of other databases, which slows down Notion a bit. If I were to point to a database with more than 200 rows to create a rollup as you showed in the projects section, would you say it would be faster? Would it affect the speed?
Hey, I have it confirmed with engineers that Formulas are more performant than Rollups. This is not measurable from my end, so your best bet is to try it out. For very complex data that is mission critical, something like PostgreSQL or MySQL is best (an actual database!)
Please HELP! I have numbers in two related tables (Table 1. Payslips, with a Property: "Salary Hrs" and Table 2. Rates, with Property: "Salary Rte") I want to create a Formula Property in the Payslip table that multiplies "Salary Hrs" with the corresponding "Salary Rte" in the related Rates table. I can't seem to get the syntax right to reference the "Salary Rte" property in the Rates table.
Hey, Jacob. If you've got a Relation that you want to pull through the rate from, it'd look like this: prop("Rates").first().prop("Salary Rte") * prop("Salary Hrs") Your relation "Rates" is a list, so you need to get an actual page object from the list with "first()" so you can reference the properties on that page. Now, this assumes you only ever attach a single Rate to each Hours page. Make sense?
How can you use a variable in an if statement? For instance, I want to set a variable where two properties subtract each other, and then an if statement to check whether that variable is grater than a value.
Great question. So "let" has the signature let(variableName, valueOfVariable, expression). variableName is the name you want to define valueOfVariable is the value you want to set "variableName" to expression is any valid formula you can think of where you can use variableName So in short, let *returns* the expression's value. Here's an example where I assign the difference of PropA and PropB to the variable "result" and then in the "expression" I check to see if it's greater than 0. let(result, prop("PropA") - prop("PropB"), if(result > 0, "Greater", "Less"))
Nice video! I trying to learn more but I have a quick question. How to sum some values itens that has a specific tag? For example, I linked 40 itens, but just 4 has a specific tag on other database. When I try to sum, the formula uses 40 itens, not just 4. HOw to specify the itens that I want to sum?
Ben, thanks for the video! Could you make a tutorial on how to display progress as a progress bar? I can’t figure out how to link different projects that are in the same database to different databases, where there will be individual checkboxes... How to link not an entire property to another database, but individual projects. I would be very grateful to you. This is perhaps the only question that is causing me great difficulties now (((
The section on lists and variables in this video show how to make a progress tracker with related tasks. You would use this method and select "Bar" as your display instead of "Ring" as I did.
Great video! I need to get dot syntax into my muscle memory. Do you know if there's any way to show filtered relations one per line? I tried .map(current + " ") and that didn't work.
@@benjaminborowski Looks like there's some issues with view filters when it comes to empty lists. Items which are returning empty lists are matching when the filter is set to "is empty" and "is not empty".
soon! Notion's API issues has been making preparations for launch very difficult. It's currently available to Notion Mastery students, but but the lower cost standalone will be later this month. Definitely before November as I am going on vacation!!
Bro, 2.0 is killing me. Thank you for clearing up a straightforward question.
You're welcome! Thanks for watching. My course goes much deeper into code fundamentals if you continue to get stuck.
notionmastery.com/formulas
Made me smile when I saw your thumbnail pop up. Immediately switched over from the other video as I know yours will likely be more comprehensive and easier to understand 😅
Cheers, Jatin. Your compliment made me smile as well. Appreciate you.
Formulas made easy! Signing up for the course now!
Thanks so much for this video. I was pulling my hair out with the "prop" terminology and beginning to cry as I couldn't even add two numbers together in two different columns. THANK YOU so very very much. Seem like every other youtube video hasn't flagged this new formula terminology. Automatic subscription. Big thanks.
That's super nice to hear. I appreciate your comment. You're very welcome.
Nice! These new formula and dot notation syntax are fantastic.
Such an upgrade, right? :)
Great video, very clear. I may or may not have cried happy tears, this update is huge and all I needed
You and me both!
So helpful. Thanks Ben!
No problem, Roxy, glad it was helpful!
So helpful, I love the update !
Little trick that maybe you know, you can reduce the YYYYMMDD into an L or l, for the formatDate function, to know if prop("date") == Today
Great tip for the viewers!
Thanks for making this video Ben! It was really helpful to see you work through examples using the new features and methods.
You’re very welcome.
Super helpful as always. Thanks Ben!
You're welcome
Thank you! Very understandable and easy to follow! :D
You're very welcome!
Great vid. Started using Notion and learning about formulas.
Glad it was helpful! Formulas can be intense, so I recommend starting small at first.
Amazing video. Thank you very much.🎉
You're welcome. I had a lot of fun making it.
As always. Love your work. 💜
Thank you so much!
Thanks!!
Welcome!
Nice video and really happy to have the new list functions. Now we just need reduce() added to go with map() - unless you know of a hacky way to get that already.
I asked for that too during the beta, lol! I'm sure there's a hacky way. I'd love to solve for it. Feel free to link me to a description (or post here) of an outcome you're trying to achieve and I'll see if I can hack it!
Great video, very clear. all that I needed. however, I'm wondering if you can create a notion formula generator and/or an online converter to/from Notion formula. I'm trying to find something like that without success s ofar
Hello Ben! How do I access/buy your course on Formulas 2.0?
It's still in development! There's a sign up at the bottom of notionmastery.com/formulas/ that you can use to be notified when it's available.
Love how clear your video is, at beginning could I have prop or name field like you did ,,so add name then add total income minus total expenses and have it calculate based on that name field, I tried and tried different methods. I need different totals for two different rows
Sorry, I don't understand your question. Can you ask it a different way?
@benjaminborowski appreciate your reply. What I ended up doing was just kept the other account separate instead of together. Because I'm new to this, I'm not sure how to rephrase, but will try. One row has bank 1 income bank 2 income bank 1 expenses bank 2 expenses...those are names on top. Then on side is bank 1...next line is bank 2. Maybe those are rows top is columns.
Then I was trying to do formula based on bank name, then income less expenses...but it didn't work..it works without the name
Very helpful. When is the end of the summer? For us not based in the US.
In the next month or so. I don't have a fixed date yet and I had a death in the family so I'm moving a little slower than I usually do. Sign up for the list and I'll keep you posted!
Thank you and my condolences. I signed up to the list straight away.
This new feature of using rollup through a formula will be very helpful to prevent large databases from freezing.
Currently, I use a database with over 50 properties that are just rollups of other databases, which slows down Notion a bit.
If I were to point to a database with more than 200 rows to create a rollup as you showed in the projects section, would you say it would be faster? Would it affect the speed?
This is my query as well... does it get faster, what are the performance benefits.
Nevertheless the extra capabilities are mind blowing.
Hey, I have it confirmed with engineers that Formulas are more performant than Rollups. This is not measurable from my end, so your best bet is to try it out. For very complex data that is mission critical, something like PostgreSQL or MySQL is best (an actual database!)
Just knowing that already makes me happy. I'll give it a try. Thank you very much@@benjaminborowski
@@Rafael-nu3mm me too! thanks for watching my video, I really appreciate it!
Any boxing day sales on the Formula Fundamentals 2.0 course? Would love to grab it if it was discounted and I am sure many others would feel the same.
Please HELP!
I have numbers in two related tables (Table 1. Payslips, with a Property: "Salary Hrs" and Table 2. Rates, with Property: "Salary Rte")
I want to create a Formula Property in the Payslip table that multiplies "Salary Hrs" with the corresponding "Salary Rte" in the related Rates table.
I can't seem to get the syntax right to reference the "Salary Rte" property in the Rates table.
Hey, Jacob. If you've got a Relation that you want to pull through the rate from, it'd look like this:
prop("Rates").first().prop("Salary Rte") * prop("Salary Hrs")
Your relation "Rates" is a list, so you need to get an actual page object from the list with "first()" so you can reference the properties on that page. Now, this assumes you only ever attach a single Rate to each Hours page.
Make sense?
How can you use a variable in an if statement? For instance, I want to set a variable where two properties subtract each other, and then an if statement to check whether that variable is grater than a value.
Great question. So "let" has the signature let(variableName, valueOfVariable, expression).
variableName is the name you want to define
valueOfVariable is the value you want to set "variableName" to
expression is any valid formula you can think of where you can use variableName
So in short, let *returns* the expression's value. Here's an example where I assign the difference of PropA and PropB to the variable "result" and then in the "expression" I check to see if it's greater than 0.
let(result, prop("PropA") - prop("PropB"), if(result > 0, "Greater", "Less"))
Nice video! I trying to learn more but I have a quick question. How to sum some values itens that has a specific tag?
For example, I linked 40 itens, but just 4 has a specific tag on other database. When I try to sum, the formula uses 40 itens, not just 4. HOw to specify the itens that I want to sum?
You will want to use the "filter" function available for lists to filter down the related items to the ones you want.
Ben, thanks for the video! Could you make a tutorial on how to display progress as a progress bar?
I can’t figure out how to link different projects that are in the same database to different databases, where there will be individual checkboxes... How to link not an entire property to another database, but individual projects. I would be very grateful to you. This is perhaps the only question that is causing me great difficulties now (((
The section on lists and variables in this video show how to make a progress tracker with related tasks. You would use this method and select "Bar" as your display instead of "Ring" as I did.
Great video! I need to get dot syntax into my muscle memory. Do you know if there's any way to show filtered relations one per line? I tried .map(current + "
") and that didn't work.
.map(current).join("
")
And keep in mind the live-preview does not show newlines and you must have wrap enabled on the column to display them
@@benjaminborowski Much thanks!
@@benjaminborowski Looks like there's some issues with view filters when it comes to empty lists. Items which are returning empty lists are matching when the filter is set to "is empty" and "is not empty".
When is your course for formulas 2.0 coming out?
soon! Notion's API issues has been making preparations for launch very difficult. It's currently available to Notion Mastery students, but but the lower cost standalone will be later this month. Definitely before November as I am going on vacation!!
@@benjaminborowski great, thank you 🙏
gibberish to me!
✅ N. keepnote versi lngkp