How to Use Notion Formulas 2.0 Like a Pro

Рет қаралды 11,914

Kat Waugh

Күн бұрын

Пікірлер: 41

@Ranaunity 3 ай бұрын

This is one of the best videos I've seen on formulas and the most helpful. Wow! Thank you

@LiliCrancloudy 4 ай бұрын

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 :)

@itskatwaugh 4 ай бұрын

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!

@RamiNassarPlus 6 ай бұрын

I like watching your videos, well organized and easy to understand... good job!

@itskatwaugh 6 ай бұрын

Thank you! I'm so glad they're helpful!!

@Ranaunity 3 ай бұрын

This was amazing. Would love more tutorials on the basics of all the formulas 🎉🙏🙏

@ThePlant-BasedClimber 3 ай бұрын

Great video, well-made and informative! Thank you!

@joeraschke 5 ай бұрын

Thank you! Now looking forward to part 2.

@itskatwaugh 5 ай бұрын

So glad you liked it!! Part 2 is here: kzbin.info/www/bejne/fGPaYZZ8hryZo7csi=VWBT4mkH27X0tAhk

@miraclemark6120 2 ай бұрын

Thank you so much for this ❤

@Nolane-o7i 6 ай бұрын

Very qualitatif, i like using notion and didn't even now you code in there, Like from france !

@itskatwaugh 6 ай бұрын

So glad to have you here! And yes - it's a game changer for sure!!

@twalliance 5 ай бұрын

Thanks vm for doing this and it's got me started using formulas 🙂

@itskatwaugh 5 ай бұрын

Yay! I’m so excited to hear that!

@AmelieHebert-Pelletier 4 ай бұрын

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!

@itskatwaugh 4 ай бұрын

Ahh I’m so glad you like it! I’m happy to answer questions, you can feel free to email me if you like!

@Mark4Jesus Ай бұрын

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.

@itskatwaugh Ай бұрын

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!

@Mark4Jesus Ай бұрын

@@itskatwaugh thanks. Yeah I can't do a plain rollup in my use case because I only want the last item requiring a formula.

@JoshZukerTravel 8 күн бұрын

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.

@itskatwaugh 7 күн бұрын

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!

@F_Alh 3 ай бұрын

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 😭)

@itskatwaugh 3 ай бұрын

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.

@enghhb 5 ай бұрын

great job!

@itskatwaugh 5 ай бұрын

Thank you!

@RonnerFTW 6 ай бұрын

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.

@itskatwaugh 6 ай бұрын

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!!

@RonnerFTW 6 ай бұрын

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

@itskatwaugh 6 ай бұрын

@@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 :)

@RonnerFTW 6 ай бұрын

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

@itskatwaugh 6 ай бұрын

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

@PowerAppsTutorial 6 ай бұрын

This looks a lot like Power Apps! 😂😎👍👍

@Ranaunity 3 ай бұрын

Where do I find part two? Thank you

@itskatwaugh 3 ай бұрын

You can find part 2 here: kzbin.info/www/bejne/fGPaYZZ8hryZo7csi=RKZWm9_qCBNH0kRn 💕

@-NiamhWitch- 2 ай бұрын

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!

@itskatwaugh 2 ай бұрын

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 :)