Notion Must-Know! How To Use The If Statement

[@vitalis]

The most underrated notion channel.

[@RedGregory]

🙏 Thanks friend. Growth is a slow road. Doesn’t matter too much though, because I love making these videos.

[@aftab_aaman]

Great, you're the best notion formula tutor in the whole notion community 👍

[@antoniodemarcus9614]

♥️

[@BohdanaTkalych]

I've been struggling with "if' function for over 40 minutes. And then I just found your video and with the first attempt everything worked! thanks!

[@AnaHiga]

You are incredible! I can't even say how many times your videos have solved my life. Thank you so much!

[@PedroFernandezRuiz]

Nice Sunday Red! Always nice to take tips from you!

[@RedGregory]

😊😊

[@nathanieljones1331]

This has been such a helpful video, thank you so much for taking the time to make this and for being so thorough in your explanations as to why you did what you did! Great job!

[@maemeite6195]

Thank you so much for the clear explanations and for sharing your complex formula method! Super useful, I’ll definitely be using it from now on. Keep up the amazing work, you’ve got a new subscribe ✨

[@andonisr]

Exactly what I was looking for in 7:12! I couldn't figure out how to use the SUM because my column is a Formula, so now it can give me a sum amount at the end! You're super!! Seriously, you're the best I've found so far in my Notion journey 🙂 Thank you so much...!

[@hendrixhein]

I am mind-blown with the functions of IF statement. There is no limit on how far you can go with IF statement in your database. Thank you for sharing

[@achrafgr5449]

Thanks, formula in notion make me go crazy

[@RedGregory]

Hope this helps 🙏

[@cm975]

Easily the best notion channel.

[@yifeiong]

you are the best notion formula instructor ! thank you very much for your efforts.

[@Alejandra-iz1mr]

soo grateful to discover this channel

[@Prismaticist]

congrats on 30k!

[@RedGregory]

Thanks!

[@FloraChristophe-qj9bx]

Thank you for sharing, you saved my day at work :)

[@scoogsy]

Really good explanation. Very practical, helped me a lot! Thank you 🙂

[@nicholasasfredo4884]

Hey Red, this was my first-day learning notion and your content really helped me. i just had a little confused here, in the video you write a formula like this= formatDate(prop("Date"), "L") what does "L" stand for?? is there any other format? except for D, M, Y ?? thank youuu

[@jaguarbrujo6164]

We really love you, Red

[@oyaoya7628]

You are so cool!! , Thank you🥰 You help me a lot.

[@waynenavarrette9761]

Crazy useful, exactly what I was looking for!

[@tetsurokanda]

In the if statement, first check the correctness of the expression, and if the answer is correct, do this, and if the answer is incorrect, do this. Also, by making the incorrect answer into an if statement, it will branch more finely.

[@mrbeginner5128]

Thanks for the Lesson!

[@Kiaskalling]

Pleas help! im trying to add the formula: "If the "date added"is within one week of being due, the priority changes to High"...if the date "date added" is two weeks of being due, the priority changes to Medium....I can't figure it out

[@miguelangelaguilarvelazque1050]

Thanks !!! Very Helpfull

[@kentaro2121]

OMGGG SO MUCH HELPFULLL

[@cricciardifi]

Great video!!! thanks 🥰

[@dumpreen9768]

you have the best notion video, but can i ask if youre able to make a video tutorial about the formula that tells you what zodiac you are depending on your birthday date

[@TeamGibson-pf9nj]

Great video!

[@hopesonhigh]

Help! I am trying to find a way to strikethrough the whole row in a table once I click on the "Done" checkbox.

[@futurythm_]

Huge thanks!

[@rosaclark9661]

Does this work for a select field? I want today's date to appear if in my select type 'Status' field 'Done' is selected, then today's date appears. I keep getting an error, "invalid left hand side of assignment operator = (char 19)". Here is the formula: if(prop("Status") = "Done", now(), ""). What am I doing wrong?

[@oskarneftel3756]

One question: I am trying to build a formula that gives me an emoji if the date of a property is tomorrow and another one if it isn’t. What I did is: if(prop(“Next”) == (pasted in what you posted for date is tomorrow), “❗️”,”🕛”) and it says there are too few arguments. help please 😅

[@sharkguy-l]

Hi. Thank you for the tutorial. But I have a stupid question: is it possible to do something in formula like - if(prop("Homework")) == true, style ("green_background"), style ("red_background") Thank you in advance

[@Mr2Lie]

Is it possible to use the code to automatically switch a tag if a checkbox associated with the datapoint is true?

[@shaennalee3752]

first off, you're the best! secondly, is there a formula to strike-through the task name when the checkbox is checked?

[@2012d7ooom]

you are the best thank you

[@theencryptedpartition4633]

I almost drove myself crazy for trying to come up with simple formula that switches every week, god I feel so stupid. I spent like 5 hours on this. I became an old man

[@SummerRockzBarcelona]

Hi there, do you know what to do if the formula box is not showing? I searched eveeeerywhere.

[@andreaingz]

Hi Red! Thank you very much for this! I have another question haha, do you use loom for creating these videos? Thank you in advance!

[@lunabeige]

How to check for duplicates in a database? I have a database where I save my web bookmarks and i want to prevent to save the same website.

[@jersonturga5707]

hi, your videos help me a lot with notion, however I can't find or create a formula that if the A date is empty, B date would add 6 months but if A date is not empty, A date would add 6 months instead, is it possible? thank you for the response.

[@facedownize]

your channel is amazing. how would you change the if statements when you have a date range? working on a travel planner, and would like the "deadline" to be like "enjoy your trip" when you are within the dates, and x days remaining until trip/days since you've traveled. how would you do this? :)

[@AhbbaNetworks]

hi how can convert from Number to word like for example 25.200 to be twenty-five and two tenths

[@alexantony007]

Does notion have a call/fetch function. My use case is that I am making a table to handle my job cards for Automobile service center. So I want an option where when I type Toyota in make column then I want notion to show only Toyota cars in make column when I am trying to add there.

[@anitasenta]

Hey! I'm just becoming immersed in Notion :) I wonder, do you know if it is possible to have multiple conditions in a formula? For example, looking to achieve something like this: if(prop("Frequency") == "Annual", prop("Recurring Amt") * 1) if(prop("Frequency") == "Semi-Annual", prop("Recurring Amt") * 2) if(prop("Frequency") == "Quarterly", prop("Recurring Amt") * 4) if(prop("Frequency") == "Monthly", prop("Recurring Amt") * 12) if(prop("Frequency") == "Bi-Monthly", prop("Recurring Amt") * 24) if(prop("Frequency") == "Weekly", prop("Recurring Amt") * 52)

[@jung-o]

Thanks for your nice video. When I follow your instruction, it says 'prop is not defined'. Could you give me any comments on this?

[@soulkiller925]

is there a way to make selection tag to a number for ex: win == 1 , lose == 2 , breakeven == 3. I'm tying to get a total count of this then dived it to get a percentage of win lose and breakeven but idk it even possible.

[@Tatibecegatto]

how do i create a formula where i have a sum of each name in my prop, like i want to know how many carbs did i eate in a week in percentage

[@otaviodecarvalho-art]

Hi Red, I'm terrible at programing, I can't write things, so I just copy the stuff you put in your follow along videos, which worked great so far, but now I need to write something, and it would be great if you (or anyone in the comment section) could help me. It's very simple (I think...) How do I make the Status propriety change from "Not started" to "In progress" when I add a Date?

[@1993ja]

I'm really struggling with a formula, somewhat similar to the 'if' statement. I want to return "High", "Medium" or "Low" for a given value range. I.e. return "low" when "Value" is less then 0.8, return "high" when "Value" greater than 1.2. And if in between, return "medium". Thing is: I only get "medium" as a return, even when "Value" is way below 0.8 or above 1.2. Is there anyone who knows what I'm missing? Below is my formula: (prop("Value") == 0) ? "" : ((prop("Value") = 1.2) ? "🔴 High" : "🟡 Medium"))

[@Mshmoylova]

Спасибо!

[@josetorresfjv84]

Parabéns pelo conteúdo e didática. Uma dúvida seria possível que algumas das funções ou operadores conseguissem analisar um valor menor em diversas propriedades e retornasse o nome da mesma? Estou fazendo uma DB para orçamento de compras e para cada coluna possuo o valor de cada fornecedor, ao final de 5 colunas por exemplo gostaria de saber qual o nome do fornecedor tem o menor preço da cotação.

[@bdhellspawn]

Amazing video, I'm getting to know formulas and I have a question if you could clarify it would be great. Is it possible for notion to calculate different cells vertically and not only orquestrate data row by row? for instance if you have 4 rows and the sum of column # No. 1 is 100 were each cell is 25. Is it possible to use the formula to get 75 total, depending on a condition if column "tags" is filled or not? Or to simplify my question, does notion enables me to control a cell referencing random cells in different rows, like excel? e.g. (=sum(F5+F7+F10+G13)?

[@mananparekh_]

The goat

[@justinecustorio2393]

red can u please, make a tutorial on a to-do list system with progress status, percentage, and more? I am entering a sound and a "should-be" working code but it seems I can't hit done to make it run, somehow. I don't know what I'm missing, maybe it is with the rollups or maybe I should be using the format command but I'm new to programming/CSS... hope i can get help with cracking it

[@zamsMG]

woww.. it's Great..

[@falkos.6535]

thanks for the impressions of formulas! just one question… is it possible to create a formula containing values of different rows?… example: adding 2 numbers of different rows.

[@brokeforever]

Can you add a count for example how many Tag1 and how many Tag 2 entries there are?

[@kdrcvk4018]

Thx

[@mariaeduardaburchardt6294]

Hey Red! Love your content, thank you! I'm trying to replicate this model of formula to nest the time of day acoordingly to the Ayurveda Clock! From 6-10 (18-22 as well) is Kapha time, 10-14 (22-2 as well) is Pitta time and 14-18 (same with 2-6) is Vata time... Anyways, been struggling with this since I have the bare minimal knowledge on formulas, been studying you channel these last few weeks! Haha. Could you maybe help me out in this one? Thanks!

[@katsmith8263]

Did you crocheted this sweater yourself?

[@anamafzal7616]

i am afraid this contain function in notion is no more identified. as all your videos' are extremely helpful. I am afraid notion is changing upgrading there formulas

[@13NZB]

Can you use the If formulas for math equations?

[@JohnDoe-lb1mg]

Where is the link to the template?

[@RedGregory]

There is no template for this video.

[@HippieP629]

I was literally looking at how to do this 15 mins ago. Get out of my head, RG

[@RedGregory]

😆😁

[@mshazelarabia]

Hi! Looking to reach you for help please. Ive found your blog to be endlessly useful and although i thought the entry about grabbing Twitter profiles from URL would be helpful, it doesn't quite work the same. Would love to know how to go about grabbing the subreddit from a URL. Thank you kindly