Відео

please a video how to create Gamification with formula

it's work thank you

Thank you for this!

Thanks for everything you do!

I was looking for hours for exaclty this. Thank you, honestly.

But no sound notifications on mobile

Is it possible to filter by more than one property? For example, status not started and checkbox not ticked. I have tried various combinations of linking 2 filters with zero success. 😢

This is exactly what I am looking for but I want to remove the ordering..e.g If I have 3 check boxes; A, B, C, representing Apple, Banana, Carror. and I click A + C...then I want the result to say "Banana missing" or alternatively Apple, Carrot.. I woudl like then to have any variation of that combination. Any suggestions?

anyone help me. I want formula suppose I have 1*1 table in database if I Press A1 cell to Select A then B1 cell will show 2 if I Press A1 cell to Select B then B1 cell will show 20 if I Press A1 cell to Select C then B1 cell will show 5 if I Press A1 cell to Select D then B1 cell will show 50 How I can do this? Please Help me

Great tutorial but currently I am using notions free plan🫥

The Venn diagram was incredibly helpful for understanding the concept, thank you.

Thank u! this is very helpful <3

Is it possible to filter for a different property instead of date? Such as person the # is assigned to?

Is it possible to do this but filter for a person instead of a date? I want to sum up # of profiles assigned per person and cannot figure out how to do that.

I don't usually leave a comment under a UA-cam video, but I have to admit that this video is a masterclass. I went through the whole channel and the content is really interesting. Thank you for sharing all these examples and knowledge. 🔥

Thank you! This is very close to what I am trying to achieve. 😊

thanks, my boy

Excellent video. Very helpful.

You absolutely saved my life!

Awesome video Ray, very valuable and educational

This button does not work if you want to "undo" your vote. Do you have any suggestion?

Hold up though, found an error here... Testing the two halves of your first formula: ".length() == map(prop("Contacts"), current.prop("Email")).length()" returns a number, but ".length() == map(prop("Contacts"), current.prop("Email")).unique()" doesn't return a number, it just returns the actual text of the email addresses in a long list. Due to this error, this check will always be false, because it's trying to compare a number to text. I checked this by simply assigning 1 single email to the checker relation, and still... no true report despite the number of emails matching the number of unique emails. To fix this (very easy) just add ".length()" after ".unique()" this will give you the NUMBER of unique emails instead of the text. Thank you for the video though! Will keep watching and note if I catch anything else.

Fantastic work. Thaks very much!

Thank you! This is the exact problem and solution I need!

what can I do when I have a "future" date? I used your formula, but in some rows, I have a date from next year, for example, and the formula result, ir returning me a negative number of months, what should I do to just show 0 for these cases?

I really appreciate your videos man, keep doing this great work

Looking forward to your continued updates, learning many useful tips from you, and wishing you all the best!

Extremely helpful information, thank you.

Thank you for the video, it was super helpful. p.s. 5:11 has me rolling 😂

Thank u very much, ur videos are so helpful ❤❤

26:00

I wanted to do it manually, because I'l be doing for all months in collumns, so I did it like this: map(prop("Expenses") .filter( current.prop("Date") >= parseDate("2024-10-01") ) .filter( current.prop("Date") <= parseDate("2024-10-31") ) ,current.prop("Amount")) .sum()

Amazing!

Have I missed something? This assumes the database is complete. Any new rows added to the first "people" database won't be associated with the "duplicate audit" database and the whole thing falls over?

You need some umph in your tone. Started yawning a couple minutes in. Other than that GREAT informative and simple. Thank you

Hi, I'm very new to Notion formulas and your video helped me figure out how to solve what I wanted to accomplish. As constructive criticism. I really struggled following what you were saying, your voice tone is very calm and welcoming but you have dips in volume and some words you say are not clear enough. Otherwise the content is really useful. Thank you!

is it possible in non member workspace?

Can be be customized to sales? Each time you make a sale, you can click an add button to keep score? Just don’t know how to set it up… Thanks!

Thank you so much for the useful and easy to follow tutorials. I've been putting off learning Notion formulas for weeks watching other tutorials but you made it so easy for beginners to pick up.

The formula really does work and this video has definitely been helpful but i think where this formula will really shine is when you say have a weekly report database linked to a tasks database. Here what I'd want to happen is whenever i check a task as done it records the completed date and uses that to add it to the corresponding weekly report. So it automatically populated my weekly report with a list of tasks completed that week. I think I'm going to need an automation function to do that since i cant use the date range (from the weekly report database) in a formula for a property (this formula prop will be something like assign this task to this weekly report) in the tasks database. If you know anyway i can do this with only using formulas it would be great.

Thanks for this! This worked for me but it's a bummer that the colors for the status or select type don't propagate through and it's just plain text.

Do you know if there's anyway to show the most recent "meeting status" in the client database? Ie if there were 3 meetings for client A and the most recent status was "Okay" i want to show that as a property in the client database.

can we do this without automations? like using formula?

Explain detailyyy

Hello! Thank you for the time you take to help everyone by creating your videos! I wanted to ask you if you know any way possible way to bring a property date (with a date and time range [start-time and also end-time]) from one database into another with a usable date property that you can add to a calendar view? I have been reading a looooooot of forums, watching videos, chatGPT, etc trying to create a Master Calendar in Notion, by bringing multiple databases date (with time start and end) properties but there is no way that I can get this right! There is a fromTimestamp formula that brings me closer, but the problem is that it does not convert the end time (only the start date and time)!!! Please!!! 🙏🏼

Thanks, I really appreciate this video.

this is very helpful, thanks so much! One thing though - I was wondering how you could get your 'output' table to dynamically update when new rows are added to the 'Input' database?

Is there any way to hide / avoid weekends?

Imagine i would Share the Link / or publish the Site. Can people also vote, if there are Not in the Team or workspace, so Random people? Thanks for the Video:)

Hi there! Could you help me with a formula to sum the cost of sub-subtasks? I was able to come up with this so far: prop("Sub-item").map(current.prop("Sub-item").map(current.prop("Cost"))) - it will show the cost of the sub-subtasks (grandchildren) separated by a comma, but I cannot figure out how to sum it instead. Thank you!