1️⃣. Task Time Estimator: 🔸Argument = input 13:25. 🔸PEMDA 14:25 🔸round trick 22:25 ➡️ 23:37 🙋🏻♀️ What is the difference between argument & expression (in the error message)? 21:00 🔸Other ways 24:50. in javascript, method vs function chaining 25:35
Hey Thomas, thank you for your work -I've learned a ton! Going through the lesson, (22 min in) and am at rounding. Just a thought that might help the use case: if someone wants to round to the nearest half hour or quarter hour instead of a decimal point, they could use 2 or 4 instead of 10/100/1000.
Hello!! I’m building out a sales pipeline and I’ve spent hours trying to figure out how to create a sales conversion rate table… im not formula savvy and thought it would be easy to do this like it is in excel. Do you have any tips?? Please and thank you!
Hi, thank you, but can you teach how to add text to formulas? for example Happy Birthday on Gallery view, thank you, or DOB on the board view again, thx
Was wondering whether formulas can count comments in a page, but I'm concluding that it can't do that yet. Still taking away and successfully applying a cleaner way to count relations with particular conditions. Thanks! Love your energy and humor. I use Notion as kind of a website and currently have a hidden multi-select property called "Attention" where if something's wrong, I mark it there, and shows up in a separate dashboard. But I don't like this workflow (gotta scroll aaallllll the way up and fit issues into categories; it's a bit disruptive), and have since realized I can just use comments to do the same. Today I learned that in a linked database, it includes a count of top-level comments for me, which is nice. Sadly I can't do anything more with that, like filter pages by number of unresolved comments. Nor does it count the comments I have on individual blocks.
The formula for counting notes is good for English. In another language (such as Polish) it will no longer work. We have variations and in this case there are 3 options: (1 - notatka), (2, 3, 4, 32, 34, 74 - notatki), (0, 5, 6, 7, 8, 9, 37, 69, 58 - notatek). What will be the formula for such a solution?
First off I'm the worst when it comes to formulas!!! I was in the middle of updating my projects and setting up my review dates. I had deleted the old formulas and was going to follow along with a video to set up new ones but low and behold the video was setting up the OLD formula. As of now I, for the life of me, cannot figure out how to do the formula for my reviews. Could you point me to somewhere EASY for this. (Like a follow along video for dummies)
Thomas, I have for example total in me minus total expenses, however I want it n one line only and it’s calculating the next row which I don’t want. Any way to make it one line only,
If you’re asking if you can, yes! I may make a video on it in the future, but I’ll be doing Zapier, Make, and Pipedream first. n8n is less attractive to the average user due to the higher starting price for cloud and difficulty of self hosting. Really cool product though.
I am trying to write a formula that will let me take my number of remaining classes divided by the number of remaining weeks to September 20th, 2024 to tell me how many classes I must complete per 1 weeks time. Rounded to the nearest tenth. I would also like to have a function that can adjust the rate based on how fast or slow I complete classes. This is what I have: round((28 - length(filter(["status"], current == "Done"))) / dateBetween(now(), parseDate("2024-09-20"), "weeks"), 1) But I'm getting this error: Function round received unexpected argument. [115,116] Please help! Lol
Yes, but also the other way around. Learning Notion formulas first helped me pick up JavaScript quicker. If your goal is to learn Notion formulas, then practicing Notion formulas will be the fastest way to do it. JS is much more complex!
Are they missing? I installed an OBS plugin that is supposed to use Whisper to create them on the fly. Maybe it didn’t work - if so I’ll see if I can get them generated when I’m back in the office Monday
Hey friends! Lesson starts at 03:46 🙂
Full timestamps:
00:00:00 - Stream start
00:03:46 - Lesson starts
00:06:43 - Formula 1: Task Time Estimator
00:38:35 - Formula 2: Simple Habit Tracker
00:49:58 - Formula 3: Next Birthday Formula
01:13:56 - Formula 4: Note Count
01:38:52 - Formula 5: Project Progress
01:52:26 - Formula 6: Audio File Duration
Dziękujemy.
1️⃣. Task Time Estimator:
🔸Argument = input 13:25.
🔸PEMDA 14:25
🔸round trick 22:25 ➡️ 23:37
🙋🏻♀️ What is the difference between argument & expression (in the error message)? 21:00
🔸Other ways 24:50.
in javascript, method vs function chaining 25:35
If you need help finishing this massive 2:37:00 Notion Course, you can watch one of my 3 Hour Study With Me Videos :D
Your talking speed is amazing, fast but crytal clear every single word. Your energy is rock 🎉
Hi, Thomas! Thank you for being so willing to share your knowledge. I’ve learned so much!
Hey Thomas, thank you for your work -I've learned a ton! Going through the lesson, (22 min in) and am at rounding. Just a thought that might help the use case: if someone wants to round to the nearest half hour or quarter hour instead of a decimal point, they could use 2 or 4 instead of 10/100/1000.
Extremely insightful indeed! Thank you very much for sharing! God bless you both!
6:21 🔖 26:27
This is very helpful, thank you so much. Your hard work makes our learning easier 💪
Hello!! I’m building out a sales pipeline and I’ve spent hours trying to figure out how to create a sales conversion rate table… im not formula savvy and thought it would be easy to do this like it is in excel. Do you have any tips?? Please and thank you!
Thanks Tommaso for the value! I'm thinking...when I create a formula, is it possible that the output shown is the same as the multi-select output?
Hi, thank you, but can you teach how to add text to formulas? for example Happy Birthday on Gallery view, thank you, or DOB on the board view again, thx
Was wondering whether formulas can count comments in a page, but I'm concluding that it can't do that yet. Still taking away and successfully applying a cleaner way to count relations with particular conditions. Thanks! Love your energy and humor.
I use Notion as kind of a website and currently have a hidden multi-select property called "Attention" where if something's wrong, I mark it there, and shows up in a separate dashboard. But I don't like this workflow (gotta scroll aaallllll the way up and fit issues into categories; it's a bit disruptive), and have since realized I can just use comments to do the same. Today I learned that in a linked database, it includes a count of top-level comments for me, which is nice. Sadly I can't do anything more with that, like filter pages by number of unresolved comments. Nor does it count the comments I have on individual blocks.
Hi there, can Notion count invoices for one project and subtract the amounts from a contract amount?
The project progress could be done with a roll-up property set to done. It also automatically doesn't show when no tasks I think
I want so much for this to work for me but Notion ignores me every time.
For the Habit Tracker, how do you round up the percentage in the progress bar if you have more than 6 habits?
How to make day column to fill automatically or the shortest way please? Iam more curious to that part than that persentage column
The formula for counting notes is good for English. In another language (such as Polish) it will no longer work. We have variations and in this case there are 3 options: (1 - notatka), (2, 3, 4, 32, 34, 74 - notatki), (0, 5, 6, 7, 8, 9, 37, 69, 58 - notatek). What will be the formula for such a solution?
First off I'm the worst when it comes to formulas!!! I was in the middle of updating my projects and setting up my review dates. I had deleted the old formulas and was going to follow along with a video to set up new ones but low and behold the video was setting up the OLD formula. As of now I, for the life of me, cannot figure out how to do the formula for my reviews. Could you point me to somewhere EASY for this. (Like a follow along video for dummies)
Thomas, I have for example total in me minus total expenses, however I want it n one line only and it’s calculating the next row which I don’t want. Any way to make it one line only,
can you do integration in n8n?
If you’re asking if you can, yes!
I may make a video on it in the future, but I’ll be doing Zapier, Make, and Pipedream first.
n8n is less attractive to the average user due to the higher starting price for cloud and difficulty of self hosting. Really cool product though.
I am trying to write a formula that will let me take my number of remaining classes divided by the number of remaining weeks to September 20th, 2024 to tell me how many classes I must complete per 1 weeks time. Rounded to the nearest tenth. I would also like to have a function that can adjust the rate based on how fast or slow I complete classes. This is what I have:
round((28 - length(filter(["status"], current == "Done"))) / dateBetween(now(), parseDate("2024-09-20"), "weeks"), 1)
But I'm getting this error:
Function round received unexpected argument. [115,116]
Please help! Lol
Is this with the new formula type ?
Yep!
@@ThomasFrankExplains Thankyouuu ✨
How to count how many business days left
Would learning JavaScript make it easier to understand Notion formulas?
Yes, but also the other way around. Learning Notion formulas first helped me pick up JavaScript quicker.
If your goal is to learn Notion formulas, then practicing Notion formulas will be the fastest way to do it. JS is much more complex!
The next birthday formula that uses the word "Let" cannot be used, why?
No way bro forgot patchy the pirate 😭
I'm a total beginner
Hi
Deaf supporter. Please add captions.
Are they missing? I installed an OBS plugin that is supposed to use Whisper to create them on the fly. Maybe it didn’t work - if so I’ll see if I can get them generated when I’m back in the office Monday
Captions uploaded; give them a few hours to process!
@@ThomasFrankExplains I know you’re usually on it about captions so assumed was a technology problem. 🤟🏿 Thank you for the wonderful information!!!
@@ThomasFrankExplainsThomas your work ethic and commitment to quality is an inspiration