Видео

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.

I really wish Notion would just provide a calculated property that combines anything in the subtask the same way Clickup does. In Clickup, some fields like Hours and Sprint Points get automatically aggregated to the parent task. Having this in Notion would be a lot cleaner than having to create a totally separate field for subtask time tracking.

great video, exactly what i was searching for! Ho could I also add the days to the formular? (to have an output like "X years, X months, X days" I tried this but its doing funky stuff: round(dateBetween(now(), prop("Date"), "years")) + "y "+ (round(dateBetween(now(), prop("Date"), "months")) - round(dateBetween(now(), prop("Date"), "years"))*12) + "m " + (round(dateBetween(now(), prop("Date"), "days")) - round(dateBetween(now(), prop("Date"), "months"))*(dateBetween(dateAdd(prop("Date"), 1, "months"),prop("Date"), "days")) - round(dateBetween(now(), prop("Date"), "years"))*12) + "d"

Thx !

bro how do i do osmething in a table dataset so if i put in dollar cash profit (gross pnl) and it automatically calculates the riskto reward i made from a trade. so basically lets say i got 1000 profit and take that to calculate the risk reward of the total 100.000 for example. if i only risk 0.5% of 100% (100.000) and i made 1000 (1% ) and the risk reward is then 2RR ,

Hello! By chance do you have a video on how to style mult-select options into a string of words? For example, the multi-select options for one entry is Jessica, John, Jermaine and I want to use a formula to style it to 'This project was done by Jessica, John and Jermaine.'

Thanks for the video. I tried the formula you used (with the modification of using a specific month), but it keeps giving me an error with the .sum() Can you help? It works with out adding a month and with out the sum to show an array. map(Appointments.filter(month(current.Date) == 6),month(now())),current.Session).sum()

2:36 🔖

3:18 🔖

There are approximately 30 employees. I enter the weekly work information of all of them. I can calculate how many hours they come per week with the formulas. How can I create a table containing all employees' shifts?

Your videos are amazing, thank you so much for them!! Though I understood the video, there is a different situation I kind need to make work, if it's even possible. I have three databases on my habit tracker setup: Entries, Habits, and Goals. Entries is related to Habits, which is also related to Goals. Goals and Entries are not related. When I make a new entry, the habit property is automatically filled, and I want the goal corresponding to that entry to show up, too. Since Goals and Entries are not related, I used the map function to show the tasks related to the habit (kinda like a rollup), and it worked, but it showed ALL the goals related to that habit. Then, I tried to use the filter and contain functions to get only the desired goals, and that's where I'm struggling. I don't want the formula to return a text, I want the goal, as the map function does, but filtered. Exemple: To build the habit of exercising more (let's call it "Hulk Out!"), I have three goals: go to the gym 2x a week on June, 3x a week on July, and 5x a week on August. The "Worked out" button on my main page creates an entry that is automatically related to the "Hulk Out!" habit. There's a view for each month on the Entries database, so on the June view I wanna see only goals with "June", but the map function returns all three goals related to "Hulk Out!", and filter+contains returns a text (it returned a checkbox at some point, too; really don't know how that happened). It's important to make it show up through a formula. I could set a new relation between Entries and Goals, and set the buttons to automatically fill the goal property, but then I'd have to edit all the buttons, for all the habits I'm tracking, in the beginning of each month, manually. And, since the idea is to share the template as well, the less editing needed, the better. My inicial idea was way more complicated than this, and this is complicated enough for me hahahaha I'd really aprecciate if you could help me out. I'm sorry if it's confusing (it probably is). Anyways, thanks for the videos!!

This video solved the problem I was having with my budget tracker. I was struggling to sort my spending categories by month, which categorises a daily spending database. This solution worked perfectly for my problems. Thank you so much! 👍