How to Use Notion Formulas 2.0 Like a Pro
Vložit
- čas přidán 9. 07. 2024
- If Notion Formulas 2.0 leave you feeling confused as heck, that changes today. Not only are we going over how to use Notion Formulas 2.0, but we’re also learning some coding basics too! That way you know WHY you’re doing what you’re doing and can apply it to lots of different Notion functions. Speaking of, we’re also looking at some Notion functions I use on a regular basis. All to prepare you for part 2… coming April 26!
00:00 Level-Up Your Notion Workspace
00:55 Coding Terms to Know
2:55 Notion Properties & their Data Types
8:50 The Notion Formula Editor
10:10 If Functions
12:52 Formatting & Commenting
16:06 Let Functions
18:23 To Number Function
19:10 Function Calling Styles
20:06 Format Date Function
21:13 Your Homework + Part 2!!!
Shop the Notion Templates I personally use!
katwaugh.com/shop
Feeling overwhelmed? Grab my FREE Life Audit Template:
katwaugh.myflodesk.com/life-a...
Notion Properties & Data Types Chart: www.notion.so/Notion-Properti...
Notion Functions List: www.notion.so/help/formula-sy...
Notion Date Format List: www.redgregory.com/notion/202...
Start a FREE Notion account here:
affiliate.notion.so/itskatwaugh
Like the layout of my video? Try Tella FREE for 7 days & get 30% off your subscription for LIFE:
tella.tv/?via=kat
Let's be friends!
IG: / itskatwaugh
TikTok: / itskatwaugh
Disclosure:
The links above may contain affiliate links, so I may earn a small commission when you make a purchase at no additional cost to you.
This video is not sponsored.
#howtousenotionformulas2.0 #notionformulas2.0 #notion #notionformulas
I like watching your videos, well organized and easy to understand... good job!
Thank you! I'm so glad they're helpful!!
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!
13:53 🔖
Thank you! Now looking forward to part 2.
So glad you liked it!! Part 2 is here: czcams.com/video/F2w0cFQWfmU/video.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!!
Thanks vm for doing this and it's got me started using formulas 🙂
Yay! I’m so excited to hear that!
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!
great job!
Thank you!
This looks a lot like Power Apps! 😂😎👍👍
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!
🔸5:40 keep in mind 🕵🏻♀️
🔸14:44 ifs
🔸15:12 comment
🔸 17:29 Let
🔸 19:12 toNumber
19:51 Dot
✅N