🙏 Thanks friend. Growth is a slow road. Doesn’t matter too much though, because I love making these videos.
@aftab_aaman2 жыл бұрын
Great, you're the best notion formula tutor in the whole notion community 👍
@antoniodemarcus96142 жыл бұрын
♥️
@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!
@PedroFernandezRuiz2 жыл бұрын
Nice Sunday Red! Always nice to take tips from you!
@RedGregory2 жыл бұрын
😊😊
@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!
@maemeite61952 жыл бұрын
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...!
@hendrixhein2 жыл бұрын
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
@achrafgr54492 жыл бұрын
Thanks, formula in notion make me go crazy
@RedGregory2 жыл бұрын
Hope this helps 🙏
@cm975 Жыл бұрын
Easily the best notion channel.
@yifeiong2 жыл бұрын
you are the best notion formula instructor ! thank you very much for your efforts.
@Alejandra-iz1mr2 жыл бұрын
soo grateful to discover this channel
@Prismaticist2 жыл бұрын
congrats on 30k!
@RedGregory2 жыл бұрын
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 🙂
@nicholasasfredo48842 жыл бұрын
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
@jaguarbrujo61642 жыл бұрын
We really love you, Red
@oyaoya76287 ай бұрын
You are so cool!! , Thank you🥰 You help me a lot.
@waynenavarrette97612 жыл бұрын
Crazy useful, exactly what I was looking for!
@tetsurokanda2 жыл бұрын
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.
@mrbeginner51282 жыл бұрын
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
@miguelangelaguilarvelazque10502 жыл бұрын
Thanks !!! Very Helpfull
@kentaro2121 Жыл бұрын
OMGGG SO MUCH HELPFULLL
@cricciardifi Жыл бұрын
Great video!!! thanks 🥰
@dumpreen97682 жыл бұрын
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-l24 күн бұрын
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
@Mr2Lie2 жыл бұрын
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.
@andreaingz9 ай бұрын
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.
@facedownize6 ай бұрын
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? :)
@AhbbaNetworks8 ай бұрын
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.
@anitasenta11 ай бұрын
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-o11 ай бұрын
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.
@bdhellspawn2 жыл бұрын
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_2 жыл бұрын
The goat
@justinecustorio23932 жыл бұрын
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.65352 жыл бұрын
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.
@brokeforever2 жыл бұрын
Can you add a count for example how many Tag1 and how many Tag 2 entries there are?
@kdrcvk40182 жыл бұрын
Thx
@mariaeduardaburchardt62942 жыл бұрын
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!
@katsmith82632 жыл бұрын
Did you crocheted this sweater yourself?
@anamafzal76168 ай бұрын
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-lb1mg2 жыл бұрын
Where is the link to the template?
@RedGregory2 жыл бұрын
There is no template for this video.
@HippieP6292 жыл бұрын
I was literally looking at how to do this 15 mins ago. Get out of my head, RG
@RedGregory2 жыл бұрын
😆😁
@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