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):
thomasjfrank.com/brain/
📝 FORMULA WORKSHEET
tf-video.notion.site/Formulas...
📚 NOTION FUNDAMENTALS (Free & Complete Notion Beginner's Course)
thomasjfrank.com/fundamentals/
🎥 CREATOR'S COMPANION (The Best Template for Content Creators - use LETSGO2023 at checkout):
thomasjfrank.com/creators-com...
🛠 MORE COURSES AND RESOURCES:
thomasjfrank.com/templates/
thomasjfrank.com/courses/
💪GET STARTED WITH NOTION:
thomasjfrank.com/usenotion/ - (this is my referral link)
⏰ 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:
Twitter ➔ / tomfrankly (best way to interact with me)
Instagram ➔ / tomfrankly
Music ➔ @ThomasFrankMusic
Main Channel ➔ @Thomasfrank

КОМЕНТАРІ: 36

@ThomasFrankExplains 6 місяців тому

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 6 місяців тому

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

@kamilkozik 3 місяці тому

Dziękujemy.

@wellthatescalatedquickly911 2 місяці тому

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.

@aliciathomas613 6 місяців тому

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

@samuelitooooo 4 місяці тому

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.

@matteomenegatto3642 2 місяці тому

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?

@MilenaHirkala 2 дні тому

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

@jamesc5801 6 місяців тому

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

@olliebluemama Місяць тому

I want so much for this to work for me but Notion ignores me every time.

@fauzanmuttaqin6543 4 місяці тому

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

@leebrendalee 4 місяці тому

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,

@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!

@maryannlennox4266 5 місяців тому

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)

@StudyWithCarlo 6 місяців тому

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

@fyou 6 місяців тому

Question: How do I get the new Notion formulas?

@ThomasFrankExplains 6 місяців тому

You should have them now! The old formula feature is now disabled.

@AshtonDeVaughn 11 днів тому

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

@covaloo 3 місяці тому

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?

@stodman 6 місяців тому

Would learning JavaScript make it easier to understand Notion formulas?

@ThomasFrankExplains 6 місяців тому

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!

@esnardojaredralph94 2 місяці тому

can you do integration in n8n?

@ThomasFrankExplains 2 місяці тому

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.

@dianaayt 5 місяців тому

How to count how many business days left

@charliesmith4105 5 місяців тому

Is this with the new formula type ?

@ThomasFrankExplains 5 місяців тому

Yep!

@charliesmith4105 4 місяці тому

@@ThomasFrankExplains Thankyouuu ✨

@frogwraps 6 місяців тому

@roomdark 3 місяці тому

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

@frogwraps 6 місяців тому

I'm a total beginner

@XeiDaMoKaFE Місяць тому

No way bro forgot patchy the pirate 😭

@CatalleyaStorm 6 місяців тому

Deaf supporter. Please add captions.

@ThomasFrankExplains 6 місяців тому

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

@ThomasFrankExplains 6 місяців тому

Captions uploaded; give them a few hours to process!

@CatalleyaStorm 6 місяців тому

@@ThomasFrankExplains I know you’re usually on it about captions so assumed was a technology problem. 🤟🏿 Thank you for the wonderful information!!!

@skubydubydu 4 місяці тому

@@ThomasFrankExplainsThomas your work ethic and commitment to quality is an inspiration