Відео

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!

This is absolutely helpful!! Thank you so much for such a great video 🙏🏻❤️

Thank you so much!

🔸2). 2:30 Filter formula for status 🌆 🔸3). 2:38 Checkbox 🔸3:50 #number prop ✅N

Hi there, with notion charts being a paid option, do you now need to get your clients to subscribe to use certain features?

Thank you!

This has been very helpful, thank you! If I wanted it to show the amount of tasks instead of listing all the tasks within a date range, how would I do that? E.g. for it to say 3 instead of Task1, Task2, Task4.

I have an error. When I click the button, the three created pages will add my own person attributes.

hey, greetings from Ukraine! that's super helpful, thank you! is it possible to filter dates that are this week/month, without manually inputting the range all the time? I appreciate your help :))

YES, you solved a problem I'd been tinkering with for months. I've been everywhere and found zero answers to this. I'm using this approach to track inventory numbers for products, thank you!

the tasks property doesnt show up for me.

9:28 why didn’t you use the map function & then added the relation property when creating the filter to show the date in the future?

These videos are amazing, I have learnt lots from them. Short and useful.

I'm first to like and to make comment

Is there a way to have text show up like a Select or Multi-Select field displays when using a formula?

Thanks for sharing! Great tool to use in a lot of ways.

I think I figured out why it was showing tomorrow’s date as today as well. When I did the formula, I tried dateBetween(Date,today(), “days”) instead of using the now() function

Is possible to hide or filtrer the weekends for the timeline? Is difficult estimate task that take more than 1 week if You can't hide the days that you don't work

Very cool ! Love your channel. So helpful

Wow! So informative. Thank you

Do you know if there's a keyboard shortcut for this?

Great video. Very informative.

Any idea how to have a character count for a page?

how to make that zero (0) is not visible in count field when there is no items?

Sir, i hope you can help me. I want to make a counter when i open anynote. Is possible?

Bro, I hope you can help me. I want make a formula it counting evertime when i open the note. It's possible?

Hi, how would I order/sort a list based on how many times the item occurs in said list? e.g. [Tim, Ben, Harry, Ben, Harry, Harry, ,] would change to [Harry, Harry, Harry, Ben, Ben, Tim]

Super helpful. Thank you

needed this, thanks

Do you have this video also in a quality where somebody actually can see anything?

Super helpful

So helpful!! Thank you

Really useful! I have been trying to filter by status for ages but was using “contains” rather than ==

1:50 thanks bro, this helped me a lot 👍

Excellent, thanks for the tip

Thanks so much for your detailed and useful videos. Besides, I want to replace a word by symbol in one sentence. Ex: Property: 1. Word: hambuber 2. Sentence. "I want to eat a hambuger" 3. Sentence for checking=> "I want to eat a h-------" >>> I want to find the formular to make 3rd property. Can you help me?

This is great, thanks!

The whole purpose and great value of the Formulas v2.0 update is to keep our databases as clean as possible, and instead of polluting them with numerous, intermediate formula properties in order to calculate something complex, incorporate all the logic/processing inside a single formula property. That’s why they provided us with countless functions to traverse the data in any way we want. Your method works fine. But your solution in 90% based on the old way of thinking, and just 10% taking advantage of the new 2.0 features. Essentially you are using just the map() & lets() functions in a very minimalistic way. You could achieve the same results (and much more) using just a single formula property in the Projects db. Through the already established relationship to the Tasks db, formulas 2.0 give you all the tools (functions) you need to traverse the data up & down, perform calculations on them, and present them in any way you see fit (for example converting minutes to hours/minutes, etc). Nice tutorial (it gets the job done) but a little bit misleading for someone who wants to actually learn the true power of formulas 2.0.