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