Notion Formulas for Absolute Beginners

Well hello there! In this stream, I'll be fully covering Notion formulas at a beginner-friendly level.

🧠 ULTIMATE BRAIN (Full Second-Brain Template - use LETSGO2023 at checkout to get $50 off):

📝 FORMULA WORKSHEET

📚 NOTION FUNDAMENTALS (Free & Complete Notion Beginner's Course)

🎥 CREATOR'S COMPANION (The Best Template for Content Creators - use LETSGO2023 at checkout):

🛠 MORE COURSES AND RESOURCES:

💪GET STARTED WITH NOTION:

⏰ 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

🐦Connect with me:
Music ➔ @ThomasFrankMusic
Main Channel ➔ @Thomasfrank

[ThomasFrankExplains]

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

[SakeJupiter]

This is very helpful, thank you so much. Your hard work makes our learning easier 💪

[wellthatescalatedquickly]

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.

[labulabuland]

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

[aliciathomas]

For the Habit Tracker, how do you round up the percentage in the progress bar if you have more than 6 habits?

[samuelitooooo]

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 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.

[matteomenegatto]

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?

[fauzanmuttaqin]

How to make day column to fill automatically or the shortest way please? Iam more curious to that part than that persentage column

[CarleneTausinga]

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!

[StudyWithCarlo]

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

[MilenaHirkala]

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

[leebrendalee]

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,

[baciliamacias]

Hi there, can Notion count invoices for one project and subtract the amounts from a contract amount?

[jamesc]

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

[dianaayt]

How to count how many business days left

[maryannlennox]

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)

[covaloo]

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?

[fyou]

Question: How do I get the new Notion formulas?

[AshtonDeVaughn]

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

[roomdark]

The next birthday formula that uses the word "Let" cannot be used, why?