Hi Kat, your videos are amazing! I've tried learning to code several times, and I've found not a single resource that was able to explain things in a simple understandable manner like you. At the same time, the speed at which you talk at and cover topics is optimal and you have a really sympathetic character. Thank you so so much for sharing your expertise here, you've really motivated me to tackle coding again, thank you :)
Hi Kat, great explanation on Notion formulas! I need help with doing math on an "Orders" table that has four columns where Column A (Items) is a related field to items on an "Inventory" table, and Column B (Qty) is text field where I can manually type a comma-delimited list of numbers representing the quantities of each item selected from Column A, and Column C (Item Prices) is a rollup of prices for each item selected in Column A. My goal is to have Column D (Total Price) as a formula to calculate the total price multiplying each Qty element with the respective Item Price element, and adding the results into a final total. Thank you for any advice you can provide for this.
Hey! So for starters, I personally wouldn’t structure your table this way. When writing the formulas, you’ll then have to make a really complicated formula that goes through each time in the “array” of your rollup and CDL property in order to do the math. Instead, I would add a quantity and total price property to your inventory database and do the math there! Even if you don’t want the properties showing in that table, you can hide them and keep them working in the background :)
If I could double like the video I would! I really like how you explain, I'm a new Notion addict and I think I will binge on your past videos and follow closely for the next ones! Do you take questions? I have a specific question for my databases, I will look for the part 2 of this video but if I can't find, maybe it can give you an idea for an other video! :D Lots of love and thank you so much!
Hi Kat. Thanks for this video! It shows how to detect the type ("Notion Property") of a Rollup. Is there a way to force / convert the type? I have a select property Rollup that Notion is automatically converting to type Text, and it's OK but I'd prefer converting it's type back to Select, as it originally was. I wasn't able to find anything how to do this.
Hey! There is no way to force a select property in this case. You could use a plain rollup and it would show as a select property, but you can only make the actual selection in the original database. If you are wanting to use a formula over a rollup, you could use the style() function to add colored backgrounds which would look closer to the select properties!
Amazing video Kat! Can I check with you please if you can help me with this: I am wanting to create a Notion formula between (2) two date rollup fields that will give me the duration of hours between them. I have tried to do this with the rollup properties but I can't get them to work. I can however do this with the date properties. The reason for the rollup properties is because I have 2 data tables, 1 capturing START and the 2nd capturing END. The data will be coming from a Notion Form, hence the 2 different tables and when you related them and add the rollup on the 3rd table that is where I want to have the formula work.
Hey! I'm glad you enjoyed the video! What I would suggest in this case is to have a property within your form database that's hidden. This can do the calculation using the dates for you before entering it into the rollup. Once you're receiving the output you would like, then use a rollup into your other database to get that information. The reason for this is that once you use a rollup or formula to pull a date from one database to another, it gets converted to an array of text strings. It's a tedious process to turn your text strings back into usable dates, so I always process my dates in the original database before linking them to another! Hope this helps!
Do the formulas only work for databases? I wanted to make something similar to 0:27 but on my home page in like a text box (as you can see I'm new to notion and dont know what anything is called 😭)
If anyone can help me... I would like to do just a simple calculation of the inputs in a column. Example, a list of prices in a column, with a total at the bottom. How would I do this? Thank you!
Fantastic Video! looking forward to part 2. Is there a way to change the color value / background value of a text based on certain conditions? Let's say I have 3 categories of price value, $1-10, $11-25, $26-50 in mind and I want notion to register the cost input I put in into each of these category and change the colors for it automatically to reflect its category? And as second note to that, will I then be able to take a formula, create a conversion rate and set a threshold, if =< than 15% change background color to green or something.
Hey! Lucky for you I just posted part 2!! :) So yes, you can definitely do that. There is a function called style() which I would recommend looking into. It's very straightforward and it will allow you to color your text for your print-outs! For the thresholds, I would use an ifs() statement to set the colors you want based on your conditions!!
@@itskatwaugh Gotcha! Got a bit stuck though and wanted to ask if I'm able to create a variable within a formula and reference it within the same formula. So I create my conversion rate by taking buying divided by people it was sent to, can't I then just use the ifs() and reference that conversion rate within the same formula? ChatGPT tell me this: In Notion, you cannot define a variable within a formula and then reference it later within the same formula directly. Each formula needs to be fully self-contained, with calculations repeated if they are used multiple times within the formula.
@@RonnerFTW Unless I'm misunderstanding, ChatGPT is wrong here 😅 It sounds like you'll want to use a let() function like I referenced in this video. That allows you to create a variable, or lets() to create multiple variables. You can store the conversion rate there and then use an if() statement within that to decide how you want to display it. I definitely recommend checking out my latest video as I go over an exact use case for this :)
@@itskatwaugh Thanks for getting back to me, after much fiddling I got all of it working except for one thing and I'm completely lost here and would like your input. I've set a relation between two databases, the second one only have two rows, pictures and videos with calculated formulas for total revenue's like this one here. lets( itemstotal, prop("items").length(), price, prop("items").map(current.prop("Price")).sum(), price * itemstotal ) All good overall but now I want the difference between said revenues for each of these rows, to know in % what's the overall difference. In excel I would just take Cell A1/A2 and get it right away, but how do I do it within notion? I assume I need to set a new variable with let() but how do I just define one specific row of each total revenue and then divide it? If you would be able to write it down for me that would be super appreciated, attaching my miserable attempt to find how to reference the specific row with a :: , or == , just don't know how to do it. imgur.com/a/WyQ3w9S
@@RonnerFTW That’s a great question. So it’s a bit funky in Notion vs. Excel because you the pages within databases don’t automatically talk to each other. In this case, what you’ll actually need to do is create a relation in your database back to itself so you can connect the photos and videos pages together. Then you’ll be able to grab the data from those rows! Hopefully that makes sense!
This is one of the best videos I've seen on formulas and the most helpful. Wow! Thank you
Hi Kat, your videos are amazing! I've tried learning to code several times, and I've found not a single resource that was able to explain things in a simple understandable manner like you. At the same time, the speed at which you talk at and cover topics is optimal and you have a really sympathetic character. Thank you so so much for sharing your expertise here, you've really motivated me to tackle coding again, thank you :)
Hey!! I'm so so happy to hear that! Coding is a great skill and it will feel so good once you get it down! I'm cheering you on!
I like watching your videos, well organized and easy to understand... good job!
Thank you! I'm so glad they're helpful!!
Thank you so much for this ❤
This was amazing. Would love more tutorials on the basics of all the formulas 🎉🙏🙏
Hi Kat, great explanation on Notion formulas! I need help with doing math on an "Orders" table that has four columns where Column A (Items) is a related field to items on an "Inventory" table, and Column B (Qty) is text field where I can manually type a comma-delimited list of numbers representing the quantities of each item selected from Column A, and Column C (Item Prices) is a rollup of prices for each item selected in Column A. My goal is to have Column D (Total Price) as a formula to calculate the total price multiplying each Qty element with the respective Item Price element, and adding the results into a final total. Thank you for any advice you can provide for this.
Hey! So for starters, I personally wouldn’t structure your table this way. When writing the formulas, you’ll then have to make a really complicated formula that goes through each time in the “array” of your rollup and CDL property in order to do the math. Instead, I would add a quantity and total price property to your inventory database and do the math there! Even if you don’t want the properties showing in that table, you can hide them and keep them working in the background :)
Great video, well-made and informative! Thank you!
🔸5:40 keep in mind 🕵🏻♀️
🔸14:44 ifs
🔸15:12 comment
🔸 17:29 Let
🔸 19:12 toNumber
19:51 Dot
✅N
Thank you! Now looking forward to part 2.
So glad you liked it!! Part 2 is here: th-cam.com/video/F2w0cFQWfmU/w-d-xo.htmlsi=VWBT4mkH27X0tAhk
Very qualitatif, i like using notion and didn't even now you code in there,
Like from france !
So glad to have you here! And yes - it's a game changer for sure!!
If I could double like the video I would! I really like how you explain, I'm a new Notion addict and I think I will binge on your past videos and follow closely for the next ones! Do you take questions? I have a specific question for my databases, I will look for the part 2 of this video but if I can't find, maybe it can give you an idea for an other video! :D Lots of love and thank you so much!
Ahh I’m so glad you like it! I’m happy to answer questions, you can feel free to email me if you like!
Hi Kat. Thanks for this video! It shows how to detect the type ("Notion Property") of a Rollup. Is there a way to force / convert the type? I have a select property Rollup that Notion is automatically converting to type Text, and it's OK but I'd prefer converting it's type back to Select, as it originally was. I wasn't able to find anything how to do this.
Hey! There is no way to force a select property in this case. You could use a plain rollup and it would show as a select property, but you can only make the actual selection in the original database. If you are wanting to use a formula over a rollup, you could use the style() function to add colored backgrounds which would look closer to the select properties!
@@itskatwaugh thanks. Yeah I can't do a plain rollup in my use case because I only want the last item requiring a formula.
Amazing video Kat! Can I check with you please if you can help me with this: I am wanting to create a Notion formula between (2) two date rollup fields that will give me the duration of hours between them. I have tried to do this with the rollup properties but I can't get them to work. I can however do this with the date properties. The reason for the rollup properties is because I have 2 data tables, 1 capturing START and the 2nd capturing END. The data will be coming from a Notion Form, hence the 2 different tables and when you related them and add the rollup on the 3rd table that is where I want to have the formula work.
Hey! I'm glad you enjoyed the video! What I would suggest in this case is to have a property within your form database that's hidden. This can do the calculation using the dates for you before entering it into the rollup. Once you're receiving the output you would like, then use a rollup into your other database to get that information.
The reason for this is that once you use a rollup or formula to pull a date from one database to another, it gets converted to an array of text strings. It's a tedious process to turn your text strings back into usable dates, so I always process my dates in the original database before linking them to another! Hope this helps!
Thanks vm for doing this and it's got me started using formulas 🙂
Yay! I’m so excited to hear that!
Where do I find part two? Thank you
You can find part 2 here: th-cam.com/video/F2w0cFQWfmU/w-d-xo.htmlsi=RKZWm9_qCBNH0kRn 💕
Do the formulas only work for databases?
I wanted to make something similar to 0:27 but on my home page in like a text box (as you can see I'm new to notion and dont know what anything is called 😭)
Yes it's only for databases! There is a text box for coding, but it's more to store code vs. formulas that actually use data if that makes sense.
If anyone can help me... I would like to do just a simple calculation of the inputs in a column. Example, a list of prices in a column, with a total at the bottom. How would I do this? Thank you!
At the bottom of each column there’s an option to calculate values! You can choose to calculate the sum and it will add it for you :)
Fantastic Video! looking forward to part 2.
Is there a way to change the color value / background value of a text based on certain conditions? Let's say I have 3 categories of price value, $1-10, $11-25, $26-50 in mind and I want notion to register the cost input I put in into each of these category and change the colors for it automatically to reflect its category?
And as second note to that, will I then be able to take a formula, create a conversion rate and set a threshold, if =< than 15% change background color to green or something.
Hey! Lucky for you I just posted part 2!! :)
So yes, you can definitely do that. There is a function called style() which I would recommend looking into. It's very straightforward and it will allow you to color your text for your print-outs!
For the thresholds, I would use an ifs() statement to set the colors you want based on your conditions!!
@@itskatwaugh Gotcha!
Got a bit stuck though and wanted to ask if I'm able to create a variable within a formula and reference it within the same formula. So I create my conversion rate by taking buying divided by people it was sent to, can't I then just use the ifs() and reference that conversion rate within the same formula?
ChatGPT tell me this: In Notion, you cannot define a variable within a formula and then reference it later within the same formula directly. Each formula needs to be fully self-contained, with calculations repeated if they are used multiple times within the formula.
@@RonnerFTW Unless I'm misunderstanding, ChatGPT is wrong here 😅
It sounds like you'll want to use a let() function like I referenced in this video. That allows you to create a variable, or lets() to create multiple variables. You can store the conversion rate there and then use an if() statement within that to decide how you want to display it.
I definitely recommend checking out my latest video as I go over an exact use case for this :)
@@itskatwaugh Thanks for getting back to me, after much fiddling I got all of it working except for one thing and I'm completely lost here and would like your input.
I've set a relation between two databases, the second one only have two rows, pictures and videos with calculated formulas for total revenue's like this one here.
lets(
itemstotal,
prop("items").length(),
price,
prop("items").map(current.prop("Price")).sum(),
price * itemstotal
)
All good overall but now I want the difference between said revenues for each of these rows, to know in % what's the overall difference. In excel I would just take Cell A1/A2 and get it right away, but how do I do it within notion? I assume I need to set a new variable with let() but how do I just define one specific row of each total revenue and then divide it?
If you would be able to write it down for me that would be super appreciated, attaching my miserable attempt to find how to reference the specific row with a :: , or == , just don't know how to do it. imgur.com/a/WyQ3w9S
@@RonnerFTW That’s a great question. So it’s a bit funky in Notion vs. Excel because you the pages within databases don’t automatically talk to each other. In this case, what you’ll actually need to do is create a relation in your database back to itself so you can connect the photos and videos pages together. Then you’ll be able to grab the data from those rows! Hopefully that makes sense!
This looks a lot like Power Apps! 😂😎👍👍
how do i move a database entry to a new page based on a score ?
If you use a linked view of your database on the new page, you can filter the view based on the score!
great job!
Thank you!
amazing content but idk why my head my blasting.... I can't understand anything still wanna customize my own notion template help me please!
13:53 🔖