This is one of the best videos I've seen on formulas and the most helpful. Wow! Thank you
@LiliCrancloudy5 ай бұрын
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 :)
@itskatwaugh5 ай бұрын
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!
@RamiNassarPlus7 ай бұрын
I like watching your videos, well organized and easy to understand... good job!
@itskatwaugh7 ай бұрын
Thank you! I'm so glad they're helpful!!
@Ranaunity3 ай бұрын
This was amazing. Would love more tutorials on the basics of all the formulas 🎉🙏🙏
@ThePlant-BasedClimber4 ай бұрын
Great video, well-made and informative! Thank you!
@miraclemark61203 ай бұрын
Thank you so much for this ❤
@Nolane-o7i7 ай бұрын
Very qualitatif, i like using notion and didn't even now you code in there, Like from france !
@itskatwaugh7 ай бұрын
So glad to have you here! And yes - it's a game changer for sure!!
@joeraschke5 ай бұрын
Thank you! Now looking forward to part 2.
@itskatwaugh5 ай бұрын
So glad you liked it!! Part 2 is here: kzbin.info/www/bejne/fGPaYZZ8hryZo7csi=VWBT4mkH27X0tAhk
@dojistar1784Күн бұрын
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.
@itskatwaugh23 сағат бұрын
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 :)
@AmelieHebert-Pelletier5 ай бұрын
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!
@itskatwaugh5 ай бұрын
Ahh I’m so glad you like it! I’m happy to answer questions, you can feel free to email me if you like!
@twalliance6 ай бұрын
Thanks vm for doing this and it's got me started using formulas 🙂
@itskatwaugh6 ай бұрын
Yay! I’m so excited to hear that!
@Mark4Jesus2 ай бұрын
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.
@itskatwaugh2 ай бұрын
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!
@Mark4Jesus2 ай бұрын
@@itskatwaugh thanks. Yeah I can't do a plain rollup in my use case because I only want the last item requiring a formula.
@JoshZukerTravel29 күн бұрын
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.
@itskatwaugh28 күн бұрын
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!
@enghhb6 ай бұрын
great job!
@itskatwaugh6 ай бұрын
Thank you!
@RonnerFTW7 ай бұрын
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.
@itskatwaugh7 ай бұрын
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!!
@RonnerFTW7 ай бұрын
@@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.
@itskatwaugh7 ай бұрын
@@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 :)
@RonnerFTW7 ай бұрын
@@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
@itskatwaugh7 ай бұрын
@@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!
@PowerAppsTutorial6 ай бұрын
This looks a lot like Power Apps! 😂😎👍👍
@Ranaunity3 ай бұрын
Where do I find part two? Thank you
@itskatwaugh3 ай бұрын
You can find part 2 here: kzbin.info/www/bejne/fGPaYZZ8hryZo7csi=RKZWm9_qCBNH0kRn 💕
@labulabuland5 ай бұрын
🔸5:40 keep in mind 🕵🏻♀️ 🔸14:44 ifs 🔸15:12 comment 🔸 17:29 Let 🔸 19:12 toNumber 19:51 Dot ✅N
@F_Alh3 ай бұрын
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 😭)
@itskatwaugh3 ай бұрын
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.
@labulabuland5 ай бұрын
13:53 🔖
@-NiamhWitch-3 ай бұрын
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!
@itskatwaugh3 ай бұрын
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 :)
@JonmccawАй бұрын
how do i move a database entry to a new page based on a score ?
@itskatwaughАй бұрын
If you use a linked view of your database on the new page, you can filter the view based on the score!
@naveentm04052 ай бұрын
amazing content but idk why my head my blasting.... I can't understand anything still wanna customize my own notion template help me please!