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!
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.
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")).
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?
@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.
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 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!
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!
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?
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
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 :)"
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?
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 🙏
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.
This is THE BEST "How to Deadline" video on the web!
Many thanks!!!
Extra Tip: prop("Done") == true ... can be written ... prop("Done"). For checkbox properties, either way returns the same result
You are doing great job and Thanks for that.
Big hugs and thanks from a sister from Malaysia for all your tutorial videos. You are amazing and definitely changing the world.
thank you so much. you dont know how appreciated i am for all of your videos! so helpful!
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!
A shining example of how to present a complex video - excellent.
Hello from Brazil, here we are discovering notion and your channel is amazing
Braziiiuuuu...
@@zelandinib.g5789 goool huehuehue e.e
Just here to share my appreciation for your existence ... literally learn everything from you !
Your tutorials are simply perfect. Thank you very much!
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.
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")).
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!
Red, always pulling through !!
all your videos are so helpful! thank you I have used so many of them to try an help me stay organized!!
You're the absolute best! Thank you so much!
You my friend, you are a life saver!
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!
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?
Great video and Good Sunday! I will implement this in my workspace:)
You always reply so quick. Thank you for the support! :)
Love your video! Thanks for sharing
I was waiting for that
Thanks ☺️
Hey, thanks for sharing content!
This is an incredible video and tutorial. Thank you for making it!
Super efficient gadget!!! I love it!! Thank you so much🥰🥰🥰
@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.
Im looking for this! Thank you
thank you so much you are so great!!
Thank you so so much!
You are a genius! Thanks for sharing :)
Hi Red! How would I combine this with the new "status" property Notion added? I love the upcoming, due tomorrow aspects of this database.
Thank you very much !!! ❤❤❤
Brilliant!
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!!
Include 'if(empty(prop("Do Date")), "",' as the first line of the formula, then add another bracket/parentheses to the end :) .
@@jamieclark4903 Thank you so much!!!! Now it's perfect for me!
@@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!
Wonderful!
it's very helful! thanks gregory :)
Head did boom, but great content!
amazing!
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!
i love you so much
You're amazing!
thank you
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?
Thanks!!!!
how can i edit the formula if there’s no due date because it appears “upcoming in 1 day”
You could add if(empty(prop("Deadline")). I did that and "upcoming in 1 day" disapeared until I insert a deadline.
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?
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
Have you found it ? If you have found then can you please tell me
@@studentx716 nope not yet
@@adaanyadisini if you found it please let me know :) thanks for replying to me
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 :)"
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?
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 🙏
Willing to bet Red has a background in programming.
Is it just me or is the Archive Part now working?
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.
You are crazy 🤣
I just loved it! 🫶
Thank you for sharing this gold piece of knowledge!
You saved me a lot of time and struggle... 😅
You're amazing!