How To Use Notion Formulas | Ep. 1: Project Management (Days Remaining To Deadline)

There's a hum in the back. Sorry about this y'all. Forgot to remove it. 🙇‍♀️

Forever grateful for this :) Can't thank you enough.

Awesome video Gregory! Do you have a beginner version of Formula tutorial?

I'm having a hard time getting the correct formula. Can you look at what I have and tell me how to fix it? "if(and(prop("Category 2") == "❓ Quiz")), if(empty(prop("PASS / FAIL"))), true)".

The Creativity and In-Depth knowledge used in this video to make a software represent such complex data is INSANEEE! 6/5 Skill Level

super thank you for the shared template!

Thanks!! very useful

if you have a status property that goes from not started to in progress to completed, how do you use a formula to say 0, 50,100?

You are a life saver. Complete amateur like me could use this knowledge to make a Notion database look snappy. Thank you!!

I work every saturday and monday. My formula for spaced repetition is the one bellow. How should I modify it to not include saturday and monday? Thanks in advance!

if(prop("S3"), dateAdd(prop("First Study Date"), 90, "days"), if(prop("S2"), dateAdd(prop("First Study Date"), 60, "days"), if(prop("S1"), dateAdd(prop("First Study Date"), 30, "days"), dateAdd(prop("First Study Date"), 1, "days"))))

Thanks

Thank you 🎉

keren banget, makasih kaa

Where were you for my GCSEs

Peace be upon you, my sister. I am using translation to write this comment to you. Thank you very much for sharing this special feature that makes you know how much is left until the final date of the goal. I wish you success and more success.

Excellent Tutorial Ms Red

Thank U

I'm am trying to do a Countdown in "Days, Weeks, Months and Years" until a Facility Lease Agreement expires in the future.

Regards

Thank you, great video. This made formulas way less intimidating. I have a question, would there be a way to do this but where every project has different specific tasks?
Thank you!

Thank you for this video! I know it’s a year old but I was wondering if there’s a way to change what the text says before putting the date? Every time I input a new task, the “Today” already shows up. Can that be changed?

How do you do a counter that stops when a checkbox is tick?

Thank you SOOO MUCH

Thank I love you 🙏🏼💗

very niche channel. perfect.

coming from an excel user, i am very impressed with Notion ability to use functions as you would in excel. this is amazing!

Fantastic, great work. thanks

How to count property vertical---final task 1 + final task 2 + final task 3 ...?

당신은 천재인가요?

After watching 100 useless videos finally found what i was looking for....thanks alot

This was extremely helpful, thanks a lot

So so so fkng BORING

This was amazing, so many possibilities going through my mind right now, I got dizzy 😄

Hey, can you tell me how to calculate the number of days from a start date to today's date, please? And thank you for the useful content.

Hey, can you tell me how to calculate the number of days from a start date to today's date, please? And thank you for the useful content.

You are awesome!! Thank you so much for this:-) I have always been so confused with formulas..Your explanations are impeccable!!

Man oh man, the effort you put in to providing such high quality - clearly explained FREE content is amazing. I tried pausing the videos and doing things myself before watching you do it once the video explained what you were about to do. I actually felt like I knew why I was doing stuff (as apposed to just doing what "miiiiight" work and hoping it doesn't mess anything). I feel like formulas are the last big thing I need to wrap my head around and I'm super excited for the rest of the series

Thanks a lot. This video is so helpful 🙏🏻😊

Absolute awesome, thanks ^^

A simple help pls? How i do if deadline prop is empty and I want the prop Past, Presente and Future empty as well?

thank you, you helped me a lot! I'm from Brazil haha ​​🇧🇷

Very helpful! Thank you!

how if I want to subtract between 2 column in a table, and want to leave the calculation empty (not 0) if any of the column is empty?

Thank you so much for sharing this video. Very informative and useful.

Cool:
Can you copy n past the formula and put it in the description?

Terrific..!!

Katrina KONZ
31 seconds ago (edited)
I wanted to automate something on Notion table but I can’t quite figure out how to.

So basically I have a column for :
- Amount
- Recurring Period (Monthly, Annually, Biannually)
- Total Recurring

I want to multiply each AMOUNT based on its RECURRING PERIOD in the TOTAL RECURRING column, ie:

If RECURRING PERIOD = Monthly,
TOTAL RECURRING = Amount x 12

If RECURRING PERIOD = Annually,
TOTAL RECURRING = Amount x 1

If RECURRING PERIOD = Biannually,
TOTAL RECURRING = Amount x 2

Can someone lend me a helping hand? Thank you 🙏

Hello, thanks for this video it taught me something again ;)
I am a student and I would like to do the same thing but to follow my courses... Let me explain:
I have several subjects (so far it's normal), in these subjects I have several sequences with big parts inside
For example : Mathematics > Sequence 1 - Numerical functions > 1. equations and inequations of the second degree / 2. generalities on the numerical functions / 2. generalities on the numerical functions / EVALUATION
What I would like to have is to follow the progression by sequence and then have a more global progression on the subject
Still with my example of maths: to have the progression of the sequence 1 (100%), of the sequence 2 (60%) and of the sequence 3 (0%) and thanks to the progression of my sequences to give me the global progression of my subject of maths (53% of progression) and all that with a deadline for each sequence by subject.


I don't know if it's possible to do it, but until now I haven't found the solution so I'd like a little help please ;)

goddammit, it's so cool and simple! somehow you explain it in way that's captivative. thank you

Hi! Thanks for the video! I have a doubt: How can I Multiply the time per my cost of hours?

Excellent video, thanks so much.

Hello Gregory. Can you please tell me if it is technically possible to set a condition with formulas so that, depending on the calendar date, the page status changes to: past, today, future? I want to achieve automatic movement of pages in board mode to different statuses.