Notion Build With Me: Smart Deadline Formula

Copy The Template and View Formula Guide: www.notion.so/redgregory/Smar...
Timestamps:
0:00 - Intro
1:06 - Overview of database functionality
2:05 - Condition #1 and #2, Hide archived tasks and signal if task is done
4:54 - Condition #3, Find if deadline lands on today, return "Due Today"
6:45 - Condition #4, Find if deadline lands before today, return "Overdue"
7:44 - Condition #5, Find if deadline lands on tomorrow, return "Due Tomorrow"
9:49 - Condition #6, Find if deadline lands within the next week, return "Due on Weekday"
12:09 - Condition #7, Find if deadline lands one week from today, return "Due Next Weekday"
13:50 - False Condition, Find if deadline exceeds one week into the future, return "Upcoming in Number of Days"
16:07 - How I use filters with the formula
17:41 - Extra Tip, Date range compatibility
19:03 - Outro
Twitter: / redgregory1
My Notion Blog: www.redgregory.com/
Discord Invite: / discord
#notion #notionformula

[@dawnrisk4849]

What a great idea! Implementing the features from these 2 videos will be my focus for the next few days. It's so helpful that you address how to connect what you're teaching to our databases already created. Thank you so much and have a great week!

[@heewonpark8420]

Your tutorials are simply perfect. Thank you very much!

[@lilithmaeangel]

Red, always pulling through !!

[@praewpraew2863]

thank you so much. you dont know how appreciated i am for all of your videos! so helpful!

[@NicfromKakarikoVODS]

all your videos are so helpful! thank you I have used so many of them to try an help me stay organized!!

[@timbushell8640]

A shining example of how to present a complex video - excellent.

[@bonjbonc]

Big hugs and thanks from a sister from Malaysia for all your tutorial videos. You are amazing and definitely changing the world.

[@joeburke6919]

This is an incredible video and tutorial. Thank you for making it!

[@xCheWy99]

Just here to share my appreciation for your existence ... literally learn everything from you !

[@mohsenalluosh]

I was waiting for that Thanks ☺️

[@sitaraalaknandashakti1956]

Amazing! I watched this video about five times and I think I'm finally starting to understand how to use formulas smartly within Notion. THANK YOU!

[@neodhesanta3487]

Love your video! Thanks for sharing

[@aniafangfang]

Super efficient gadget!!! I love it!! Thank you so much🥰🥰🥰

[@user-hj4dk8xt6g]

Hey, thanks for sharing content!

[@jeyga7811]

You my friend, you are a life saver!

[@PedroFernandezRuiz]

Great video and Good Sunday! I will implement this in my workspace:)

[@RedGregory]

You always reply so quick. Thank you for the support! :)

[@RedGregory]

Extra Tip: prop("Done") == true ... can be written ... prop("Done"). For checkbox properties, either way returns the same result

[@vishaljagad5660]

You are doing great job and Thanks for that.

[@congloinguyen4]

Im looking for this! Thank you

[@TraceyMwendwa]

You are amazing! Ihave been going nuts on how to do this with a date range. This is life changing with my goals page. Thank you!

[@TraceyMwendwa]

I have one question though, what if the deadline propery is empty and you do not want anything written on the action formula propert, howdo you go about that?

[@m_acsp]

You are a genius! Thanks for sharing :)

[@itsleane]

thank you so much you are so great!!

[@vanessagladv458]

Hello from Brazil, here we are discovering notion and your channel is amazing

[@zelandinib.g5789]

Braziiiuuuu...

[@caiohenrique8466]

@@zelandinib.g5789 goool huehuehue e.e

[@randyakmalsyah6080]

it's very helful! thanks gregory :)

[@thanhthanh5613]

Thank you very much !!! ❤❤❤

[@AnitaAsani]

Thank you so so much!

[@csjazzalloy]

Wonderful!

[@karinaglf]

You're amazing!

[@kpro9047]

Brilliant!

[@thelstan8562]

amazing!

[@migsmartinez8039]

Thanks!!!!

[@sophiechung2847]

i love you so much

[@Emmasplaylist98]

Hi Red! How would I combine this with the new "status" property Notion added? I love the upcoming, due tomorrow aspects of this database.

[@athenacriativa]

thank you

[@melvin9060]

At the begenning of the program, you could add if(empty(prop("Deadline")) in order to avoid formula writing "upcoming in one day" even if you didn't insert a deadline.

[@zenuromzero9224]

that's what I was looking for, how to do that, can you tell me, please? I tried, but using the if statement, it says: type mismatch, " " is not a date. How to make it show "nothing" for no deadline...? Edit: Done, used format(prop("Deadline")) for it, thanks for giving me the idea to use if(empty(prop("Deadline")).

[@studiowani1012]

Head did boom, but great content!

[@VR-ms1xf]

Hey, thank you for this! Just a question.. when i have a task with a time, it doesn’t switch to archive.. is there a workaround for that?

[@Mark4Jesus]

@5:05 I knew there was some reason prop("Date") == now() was not working... now() returns the time... thanks for splainin' that. They should just have a today() function.

[@Jayyluu]

Hi. I want to use the formula with the date range so that it shows the progress tags by date. for example today is Jan 18, my range is Jan 17 - Jan 22, so the tag would be "on-going". is it possible to set up a formula in this case?

[@jessicabuchanan6174]

what is the best way to get ahold of you with questions??? I don’t have a twitter account and it says the Discord link has expired 😔 but in case you can just comment back, I have a database for keeping track of all my plants and their schedules. I enter in the last watering date for instance, and i have another column that lists the number of days in between waterings, so how would i be able to automatically populate when my next watering date will be based on those two properties since you can’t combine dates and numbers??? Anything helps!! thanks so much! your videos are pretty much the only ones I can watch that make the most sense so thank you for posting them!

[@dyna7184]

If I use multi select property instead of checkbox property for the status of the tasks, can I still use the same formula to get the same result ? Or I need to use different formula. Please help me 🙏

[@brunafparanhos]

What an amazing video! Thanks for sharing your knowledge with us! How can I do to leave "Action" clear when I have a task with no defined deadline? I tried the formula (loved it!), but when the deadeline is clear, the Action comes as "Upcoming in 1 days". Thank you again!!

[@jamieclark4903]

Include 'if(empty(prop("Do Date")), "",' as the first line of the formula, then add another bracket/parentheses to the end :) .

[@brunafparanhos]

@@jamieclark4903 Thank you so much!!!! Now it's perfect for me!

[@alanislani1501]

@@jamieclark4903 You're an ANGEL, I've been trying to figure out how to make this work for DAYS and was about to give up! Thank you so much Thank you @Bruna Paranhos for asking!

[@ian4ng]

I am trying to write a formula that will create a due date for a task to be completed from a specific date in the future. There is a specific no. of days (i.e. 120 days) and will create a notification to the assigned person to complete. Do you have a video tutorial for this already made?

[@caramelcookie1765]

Willing to bet Red has a background in programming.

[@ecopsorn]

Hi Red. Your discord link is no longer working. I have a simple scenario I don't have a solution for it though lol. Problem: I want to let me show how many years, months and probably days there are left between a date in the "far" future" and today. Is that possible? I use "dateBetween(prop("Deadline"), now(), "years")" so instead of the "years" it should display me not a rounded "years" but also how many months are left.

[@alyaadlyna2948]

how can i edit the formula if there’s no due date because it appears “upcoming in 1 day”

[@melvin9060]

You could add if(empty(prop("Deadline")). I did that and "upcoming in 1 day" disapeared until I insert a deadline.

[@sidreddy7030]

Is it just me or is the Archive Part now working?

[@adaanyadisini]

Is there a formula so if i don't put the deadline it show "upcoming" or "empty" because sometime I don't really have a deadline yet and if I don't put a deadline it always sow 1 days left and it kinda freak me out

[@studentx716]

Have you found it ? If you have found then can you please tell me

[@adaanyadisini]

@@studentx716 nope not yet

[@studentx716]

@@adaanyadisini if you found it please let me know :) thanks for replying to me

[@alanislani1501]

Jamie Clark answered this 11 months ago! "Include 'if(empty(prop("Do Date")), "",' as the first line of the formula, then add another bracket/parentheses to the end :)"

[@linconyudi3388]

I just loved it! 🫶 Thank you for sharing this gold piece of knowledge! You saved me a lot of time and struggle... 😅

[@MinhPhan-vr8ib]

You're amazing!