Great. So good. Thanks for the info. It was short, concise and appropriate. I found exactly the information I was looking for and some extra inspiration as well. Keep up the good work :)
Hi Danny -- thank you so much for making this so straight forward ! I ran into a snag though in formatting a date to show the week number. So how can i adjust the formula so if the day is Sunday, the returning week number is associated with the prior week number. I like to have count my week by Mon - Sun, as opposed to Sun to Sat. So bc notion defaults to Sun to Sat, my sundays get put in wrong week number for me.
I am glad you found the video useful. If I am understanding correctly the issue may be in your date settings as you can choose Monday or Sunday as the week start. Go to your settings, account and then see what it selected. If that doesn't solve the issue let me know and I will explore deeper 😁
i just wanted to get a year in type thing, where it shows a square that is the year and when i click it goes indepth like that, i am doing my game tracker so i wanted to know how many games is finished this year
Hello there! Thanks for this awesome info. I am trying to input just a Month and Day of the Month into a birthday field for my contacts. I am not interested in the year they were born, but need to know day of the year for obvious reasons. When using the formula: formatDate(prop("Birthdate"), "MMM") everything is fine. It is when I want to add in the day of the month where I come into issues. Any ideas on how to get around this?
@DannyHatcherTech do you know if Notion has the ability to read the time duration between 2 seperate records? IE, Record 1 has 26.10.24 10am and Record 2 has 27.10.24 4PM time. I would think the formula needs to relate to something so it can run, however, I wondered if you knew how this could work?
A date property is a manual property. Formulas can automatically change but date properties can't. If you are using the dat for a database view you can change the calendar by option to a formula property. Hope that helps 😁
I don’t know if I am trying to apply this the same way you explained it. I am still looking for a way to make my birthdays database to show me (in calendar view) the coming birthdays in an automatic recurrent way. For now I made a formula that uses the birth date and adds the age (using the dateBetween) + 1 extra year to show when the next birthday is coming. I’m now stuck on trying to turn/relate this formula’s return value into a date property, without it losing the ability to auto change when the date passes and give me the option to set a notification reminder. I don’t know if I’m asking for to much, but in my head it sounds feasible and not soo complex. @Danny Hatcher Please tell me if I’m on the right track or if I should just drop it. Thanks for this amazing videos!! Really helpful explanations and very concise :)
So you can make a formula output a date format so it shows on the calendar but you will need to manually set reminders as it is not a date property. Hope that helps.
@@DannyHatcherTechI'm on my way to make my workspace as ADHD friendly as possible and as I always forget birthdays, I thought Notion could help me a lot on this matter. I figured it was a little to much to ask it to do all by itself hahaha but I had to try and the way you say still helps me a lot. Thanks for the quick answer! 😊
@@joaquinduran917 I reply to as much as possible. RUclips doesn't notify about everything. If you have more questions join the discord and ping me a message 😁
I am not sure what you mean by prioritize the end date but if you only want to show an end date for a date property in a formula you can use the end() function.
Hi Danny, thanks for the videos!! I'm importing article columns from Zotero (a citation manager) and I would like to keep track of the week that they are imported and add a row. is there any way to automatically set it to the most recent monday upon creation of the row?
Hello. Thank you for a video. How can i make duration property? For example, if i want to make a certain everyday tasks and drag and drop them in the timeline with exact number of minutes. Thank you in advance!
Not 100% what your looking for. If you want a constant number, it can be in a formula property so every task has a value. If the duration changes depending on the task it can be automatic in a formula property or manual in a number property. 😁
Great video, I managed to make a week number column, but since I set it to the first day of the week being a monday, it does show that in the calendar but the formula is calculating it for sunday being the first day of the week, making that day already in the next one with the displayed week , is there any way around this?
Because the Notion formulas works on a set of commands you need to use that and then adjust the output. If it is 1 day ahead, take 1 day. Just a case of doing a little math at the end. Not ideal I know.
@@DannyHatcherTech I'm still a noob at this but could you send me the correct formula? right now i have formatDate(prop("Date"),"w") i've tried dateAdd and all that but Í still have no clue what I'm doing
I am not sure what views you are referring to. If you want to see anything for today you can use a filter. If you are looking to sort the database you can do that by just the date property. Hope that helps.
I am not sure if you can change the calendar settings yet. I know they are working on including other options. Maybe reach out to their support using the ? at the bottom right of the screen.
Hey, I'm trying to isolate just the end time so I can show the time I start a task and the time I end the task. I was trying to combine -- end(prop("Date")) with formatDate(prop("Date"), "LT") -- but I couldn't get it to work. Do you know if it's possible? And what is the formula I would need??? Thanks
Hi Danny! Thanks for such an informative video! I do have one question-- my Notion date property currently displays dates as "February 18, 2022" but I'd like it to show the abbreviated month instead, for example "Feb 18, 2022". How can I configure Notion to make this my default setting, just like how it appears for you? Ideally, I'd like to achieve this without the need for formulas :)
The dat property in a database has settings when you enter information with an option for format and timezone. It is a database setting, not global but once it is set for the database it is set for all pages in it.
@@DannyHatcherTech Thanks for the reply! Sorry not sure I understand completely yet-- there isn't an option on my "Date format and timezone menu" for an abbreviated month. Can't figure out how to alter the setting for my database and all pages in it.
Great tutorials! I tried to change the date property following your instructions but in my formula window there is no "Files" option. Is there something that I am missing? 🤔
@@DannyHatcherTech Thank you so much for replying, Danny. In my table it has to be a different column's property name, though. The same column's name strangely does not appear as an option in the formula window. 😅 It works for me! Thank you again for the beautiful date format that now makes my tables perfect.
If your on a computer it will open the top page of you favourites so move the page you want there. If you are on mobile you can create a link from the page to you phone dashboard. (I know you can but I personally don't)
Great info! Can you help with importing dates from CSV? I've tried so many things but can't get it to work. I want to add (merge) the csv data into an existing field. I've had some luck getting it in but it arrives as text. When I change to date, the data disappears?!?! Thanks in advance :)
I have done a video with excel and Google sheets into Notion which what you are looking for. Essentially it comes down to the format the date is exported in so Notion reads the csv as a date format rather than text 😁
This is a beautiful tutorial! Is it possible to convert a mention into a date? I wanted to be able to type @now because that is less annoying than having to click to include time, and then going to the top to choose the time. I am doing @n in a text field which lets me just choose the day and current time all in one step. No typing from me except the @n and tapping the right date and time that is displayed. When I do an if statement, it says the field is not empty but it doesn't display anything using prop("Start") I think it is just seeing the space at the end of the time. If I delete the space it thinks the field is empty even though it has a mention in text in it. I am checking with this formula if(prop("Start") == "", "nothing", "something")
@@DannyHatcherTech support told me they would pass my request on. Just looking for an easier way to enter times other than having to set some settings for every record. It should at least be where you can set it per database
Time is an addition to the date property that has to be on. Then the formula you use can be any that shows the time and take whatever else is there. I don't think there is a setting for just the time. 😁 Replace formula may need to be used.
@@DannyHatcherTech Hi, I had the same question. Because I've added a start time and end time - how could this be shown? The formula with LT only shows the start time
@@user-rv8sl6bm9e ah ok, so start("date property") should output the first date and end("date property") will output the second. You can adjust the format of the first date by changing the first section and then the same for the second. I hope that makes sense 😁
How can I make the formula display the date as of making the submission without the date updating? So I can easily log journal submissions by hitting new and it populate the current date and time?
@@DannyHatcherTech yes I've resolved to sticking with the way I've been doing it. But I'm still able to use Notion to enhance everything and improve my record keeping. Thanks for the reply.
If your looking for a countdown, you can use a rollup or formula depending on the database setup. Using a formula with date property works for most cases.
Is there a way I can input those formula without changing the property to "formula" coz I still want the property to on calendar so I can still click the box and show me calendar.
@@DannyHatcherTech sorry what I mean is date. when you click on the box under the date property it will pop up a calendar to pick a date. but if you do this using formula. and wanted to change the date that has been entered through formula. the pop up calendar doesn't appear. you gonna type it manually.
How do i just input the time? Not current time, but custom time. Like I want to put today that I went to sleep last night at 01:20. How do I do that? Thanks!
You can do that natively without formulas. When you go to into the date property there is an option that says "include time" and that lets you select a timestamp 😁
@@RoZaxTheGreat if you just want the time, you can write it as a number or text property. It depends what you want to do with it. Essentially, why are you tracking it, and what will it be used for...
@@DannyHatcherTech thanks for the reply. I want to write time slept, time woke up and then a formula to calculate hours and mins spent sleeping. But I dont this is possible?
@@DannyHatcherTech ↯ I'm a complete equation noob, so that's gone straight over the top of my head. Right now I have: formatDate(prop("Date"), "LT") Appreciate the help Danny!
@@DannyHatcherTech ↯ I feel like I'm trying to do surgery with a hammer haha. if prop("Date"), true formatDate(prop("Date"), "LT"), false "") This is probably completely and utterly wrong on so many levels haha
@@madebypanic close. if(empty(prop("Date")), formatDate(prop("Date"),"LT"), "") so if the date property is empty put the date stuff if not put nothing which is the 2 " marks. Hope that helps 😁
Hello, Can you please help me, I wanna know the formula that shows the week of the month in notion ( for example Sep 12 = week 2) or April 23 = week 4, in general shows the week number based on the current date, I have a formula that shows the week of the year , but I don't need this. Thanks
Hi, there is not a natural formula in Notion that lets you do that. You would need to play around with the dates as each month has a different amount of days and starting points. I will put it on my list of things to work out but I can't currently think of a solution. Sorry. 😁
@@DannyHatcherTech Thanks mate , I have another question, Is it possible to assign a formula to just one row in notion? for instance row 1: prop("A") * prop("B") * 0.094 and using another formula to row 2 prop("A") * prop("B") * 0.05 when I change the values all columns data change!
@@editsbyzed not inside the database. The formula will be applied to every column (property). You would need to put in queries into the formula to account for it. You could bounce the information using a relation and rollup, then do the calculation and bounce it back with the same process. Very dependant on how the databases are set up, and what criteria the calculations need. Hope that helps 😁
How do you get the RELATIVE date ? theres an option when you have date field to show relative - however I cant find how to do that with the format date option. Also since you cant just reference a column that has a date with the style because it grabs that original date property im stuck... anyone know how to do this ?
How do you show RELATIVE formula? Can't believe nobody tells it online. I want a formula that's "DATE: " + formatDate("Date"), relative but there's no way to do it. I want it to say "Date : today 1pm" or "Date: tomorrow 6pm"
I have stopped using Notion and use Obsidian now but if the formula's work the same, the relative function is a setting in the date property. If you are using a formula you would need to create the relative setting in the output you display.
But the point is you can't select and change the date in the Formula property so you would have to keep two properties visible, the date property where you make the changes and the Formula one where you see it the way you want. This kind of defeats the puprose. If I'd like to see the date as 13 Nov instead of November 13, 2022, then I''d actually be seeing both and having two columns in my database which is even worse than the original too clumsy November 13, 2022.
Your your changing the date using a property yes, but you could change the date in a calendar view, timeline view or using any auto filter that alters the date property meaning you would view the formula only. All depends how you change the date property 😁
@@DannyHatcherTech Ah cool, I've tried that briefly, will check again! I was also thinking it would also be nice to be able to add "?" or "N/A" as date, which is different from just having it blank 😅
10/10 would recommend. This man killed it on a podcast with me today and I can confirm that he knows what he’s talking about when it comes to notion!
Thanks Demetri. Congrats on 1000 subs! You have some great stuff going on over there keep it up.
Great. So good. Thanks for the info. It was short, concise and appropriate. I found exactly the information I was looking for and some extra inspiration as well. Keep up the good work :)
Thank you. I am glad you found it useful 😁
Finally!!!
A simple way to do this!!!
Sooo grateful.
Glad I could help😁
Hi, Danny! Thanks fot this straight forward and useful information, I'm very, very helped! Hope you are always healthy and happy, Danny! ^^
Simple and effective. Thanks Danny!
Glad I could help 😁
Hi Danny -- thank you so much for making this so straight forward ! I ran into a snag though in formatting a date to show the week number. So how can i adjust the formula so if the day is Sunday, the returning week number is associated with the prior week number. I like to have count my week by Mon - Sun, as opposed to Sun to Sat. So bc notion defaults to Sun to Sat, my sundays get put in wrong week number for me.
I am glad you found the video useful. If I am understanding correctly the issue may be in your date settings as you can choose Monday or Sunday as the week start. Go to your settings, account and then see what it selected. If that doesn't solve the issue let me know and I will explore deeper 😁
Thank you a loooooooooot!!! You helped me so much!!! Thank you thank you thank you
Glad I could help!
Found something in this tutorial that I can use..thanx Danny
Ah I am glad it helped. As long as there is 1 little bit in each video I am doing my 'job' aha
Feels like learning chinese
Trust me, I was in your shoes a couple years back.
Just saw your interview with Demetri Panici and subscribed to your channel. Looking forward to watching more of your videos!
Ah good to see you Dan. It was a great conversation. Are you a Notion user?
@@DannyHatcherTech Not at the moment but I will be looking into it!
Great > Thank you So much for sharing
Glad you enjoyed it
Thank you!
So HELPFUL!
Glad to hear it 😁
i just wanted to get a year in type thing, where it shows a square that is the year and when i click it goes indepth like that, i am doing my game tracker so i wanted to know how many games is finished this year
Is the a way to create a column "ended date" that populate when the status of a task is changed to done?
Sorry I stopped using Notion a few years back now so am not sure.
This was great, thank you!
Glad I could help 😁
Hello there! Thanks for this awesome info. I am trying to input just a Month and Day of the Month into a birthday field for my contacts. I am not interested in the year they were born, but need to know day of the year for obvious reasons.
When using the formula: formatDate(prop("Birthdate"), "MMM") everything is fine.
It is when I want to add in the day of the month where I come into issues.
Any ideas on how to get around this?
You should be able to put dd mm in the "" and it show the day. The syntax may have changed since I last looked so worth checking but try putting dd 😁
Is there anyway to show the season? example Fall 1882
You would need to input the date range I think into a formula.
Brilliant tutorial - thank you!
Thanks Anna, I am glad it was helpful 😁
Thanks a lot ✨
Glad I could help
Thank you! This came in handy~
I am glad it was useful 😁
@DannyHatcherTech do you know if Notion has the ability to read the time duration between 2 seperate records? IE, Record 1 has 26.10.24 10am and Record 2 has 27.10.24 4PM time. I would think the formula needs to relate to something so it can run, however, I wondered if you knew how this could work?
@@JoshZukerTravel if they in the same page yes, different pages maybe but I stopped using Notion a few years back now.
Hi, is there a way to edit a date column in a table view all at once? I have a habit tracker table for 2022 and I want the same table for 2023.
You can bulk change cells but holding shift and selecting all the cells.
Hi, do you know how to make a Date column match a date seen in a formula column?
A date property is a manual property. Formulas can automatically change but date properties can't. If you are using the dat for a database view you can change the calendar by option to a formula property.
Hope that helps 😁
I don’t know if I am trying to apply this the same way you explained it.
I am still looking for a way to make my birthdays database to show me (in calendar view) the coming birthdays in an automatic recurrent way. For now I made a formula that uses the birth date and adds the age (using the dateBetween) + 1 extra year to show when the next birthday is coming. I’m now stuck on trying to turn/relate this formula’s return value into a date property, without it losing the ability to auto change when the date passes and give me the option to set a notification reminder.
I don’t know if I’m asking for to much, but in my head it sounds feasible and not soo complex. @Danny Hatcher Please tell me if I’m on the right track or if I should just drop it. Thanks for this amazing videos!! Really helpful explanations and very concise :)
So you can make a formula output a date format so it shows on the calendar but you will need to manually set reminders as it is not a date property.
Hope that helps.
@@DannyHatcherTechI'm on my way to make my workspace as ADHD friendly as possible and as I always forget birthdays, I thought Notion could help me a lot on this matter. I figured it was a little to much to ask it to do all by itself hahaha but I had to try and the way you say still helps me a lot. Thanks for the quick answer! 😊
@@joaquinduran917 I reply to as much as possible. RUclips doesn't notify about everything. If you have more questions join the discord and ping me a message 😁
Seriously! How do you find out this stuff? Awesome!
It comes by spending to much time playing and building on Notion for myself and clients aha.
Danny Hatcher - bliss! I see comments of yours every time I watch a notion vid on YT - it is great seeing your interaction!
do have something like this where i could prioritize the end date?
I am not sure what you mean by prioritize the end date but if you only want to show an end date for a date property in a formula you can use the end() function.
@@DannyHatcherTech thank you so much! yes that’s what i meant. thank youuuu!!!!
Hi Danny, thanks for the videos!!
I'm importing article columns from Zotero (a citation manager) and I would like to keep track of the week that they are imported and add a row.
is there any way to automatically set it to the most recent monday upon creation of the row?
You could do it with a formula but I use Obsidian and Zotero and use the annotation day as my signifier.
Hello. Thank you for a video. How can i make duration property? For example, if i want to make a certain everyday tasks and drag and drop them in the timeline with exact number of minutes. Thank you in advance!
Not 100% what your looking for. If you want a constant number, it can be in a formula property so every task has a value.
If the duration changes depending on the task it can be automatic in a formula property or manual in a number property. 😁
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 can use the dateBetween function with a date property for the start date and then use the now() function for a dynamic today date. 😁
Thank you
Great video, I managed to make a week number column, but since I set it to the first day of the week being a monday, it does show that in the calendar but the formula is calculating it for sunday being the first day of the week, making that day already in the next one with the displayed week , is there any way around this?
Because the Notion formulas works on a set of commands you need to use that and then adjust the output. If it is 1 day ahead, take 1 day.
Just a case of doing a little math at the end.
Not ideal I know.
@@DannyHatcherTech I'm still a noob at this but could you send me the correct formula? right now i have formatDate(prop("Date"),"w") i've tried dateAdd and all that but Í still have no clue what I'm doing
@@DeerNeya I will make a template for it at some point but my day is very busy today, so just keep your eye out 😁
Cool, Danny! Do you also know how to always show Today first, and then upcoming + past events?
I am not sure what views you are referring to. If you want to see anything for today you can use a filter. If you are looking to sort the database you can do that by just the date property. Hope that helps.
hi thanks this was really helpful, can you help me change the dates? i want to have hijri (persian) calendar on my notion but i dont know how to do it
I am not sure if you can change the calendar settings yet. I know they are working on including other options. Maybe reach out to their support using the ? at the bottom right of the screen.
@@DannyHatcherTech thanks for replying, i'll try that
how would you set it up so that it shows the time range 7:30am - 8:00am?
Hi, assuming you have the time setting on the date property you should be able to use m for minutes and for hours.
Hey, I'm trying to isolate just the end time so I can show the time I start a task and the time I end the task.
I was trying to combine -- end(prop("Date")) with formatDate(prop("Date"), "LT") -- but I couldn't get it to work.
Do you know if it's possible? And what is the formula I would need???
Thanks
I don't use Notion anymore sorry.
@@DannyHatcherTech :(
Hi Danny! Thanks for such an informative video! I do have one question-- my Notion date property currently displays dates as "February 18, 2022" but I'd like it to show the abbreviated month instead, for example "Feb 18, 2022". How can I configure Notion to make this my default setting, just like how it appears for you? Ideally, I'd like to achieve this without the need for formulas :)
The dat property in a database has settings when you enter information with an option for format and timezone.
It is a database setting, not global but once it is set for the database it is set for all pages in it.
@@DannyHatcherTech Thanks for the reply! Sorry not sure I understand completely yet-- there isn't an option on my "Date format and timezone menu" for an abbreviated month. Can't figure out how to alter the setting for my database and all pages in it.
The option is not there like you said. Sorry but you have to use a formula
Great tutorials! I tried to change the date property following your instructions but in my formula window there is no "Files" option. Is there something that I am missing? 🤔
The formula box won't have a files option unless you have named your property files. Hope that helps 😁
@@DannyHatcherTech Thank you so much for replying, Danny. In my table it has to be a different column's property name, though. The same column's name strangely does not appear as an option in the formula window. 😅 It works for me! Thank you again for the beautiful date format that now makes my tables perfect.
Is it possible to make notion open a certain page whenever I launch the application?
If your on a computer it will open the top page of you favourites so move the page you want there. If you are on mobile you can create a link from the page to you phone dashboard. (I know you can but I personally don't)
Thanks
Great info! Can you help with importing dates from CSV? I've tried so many things but can't get it to work. I want to add (merge) the csv data into an existing field. I've had some luck getting it in but it arrives as text. When I change to date, the data disappears?!?! Thanks in advance :)
I have done a video with excel and Google sheets into Notion which what you are looking for.
Essentially it comes down to the format the date is exported in so Notion reads the csv as a date format rather than text 😁
@@DannyHatcherTech Awesome! Thanks for the quick reply :) Can you show me what the sheets format looked like? No probs if it's too much trouble.
Better still, can you link the video lol!
@@DannyHatcherTech I figured it out. It was incorrect date format, also Google sheets works best, not Excel.
This is a beautiful tutorial!
Is it possible to convert a mention into a date? I wanted to be able to type @now because that is less annoying than having to click to include time, and then going to the top to choose the time. I am doing @n in a text field which lets me just choose the day and current time all in one step. No typing from me except the @n and tapping the right date and time that is displayed. When I do an if statement, it says the field is not empty but it doesn't display anything using prop("Start") I think it is just seeing the space at the end of the time. If I delete the space it thinks the field is empty even though it has a mention in text in it. I am checking with this formula
if(prop("Start") == "", "nothing", "something")
To my knowledge there is no way to change a mention into a date property as they are two different input styles.
@@DannyHatcherTech support told me they would pass my request on. Just looking for an easier way to enter times other than having to set some settings for every record. It should at least be where you can set it per database
@@brendalg4 there are hotkey shortcuts in the date property but that is still fairly manual.
Hi, how could the formula be to show only the start time and end time? Thanks
Time is an addition to the date property that has to be on. Then the formula you use can be any that shows the time and take whatever else is there. I don't think there is a setting for just the time. 😁
Replace formula may need to be used.
@@DannyHatcherTech Hi, I had the same question. Because I've added a start time and end time - how could this be shown? The formula with LT only shows the start time
@@user-rv8sl6bm9e the start() and end() functions could help you format it but time in Notion can be finicky due to hours minutes and seconds. 😁
@@DannyHatcherTech Thanks for your reply! I tried [formatDate(prop("Date"), "start(LT)", "end(LT)" ] but it says syntax error
@@user-rv8sl6bm9e ah ok, so start("date property") should output the first date and end("date property") will output the second.
You can adjust the format of the first date by changing the first section and then the same for the second.
I hope that makes sense 😁
How can I make the formula display the date as of making the submission without the date updating? So I can easily log journal submissions by hitting new and it populate the current date and time?
know what I mean?
Unfortunatley there is no way that I know of to do that in Notion apart from use the last edited property but that changes.
@@DannyHatcherTech yes I've resolved to sticking with the way I've been doing it. But I'm still able to use Notion to enhance everything and improve my record keeping.
Thanks for the reply.
is there a way i can setup to dos and it shows how many day i have left to complete it?
Yes there are lots of different formula combinations you can use.
I believe there is a working example in the templates page.
@@DannyHatcherTech thanks i tried looking through the formulas but i couldn't find which one to use?
hello how can I see days remaining for a date?
If your looking for a countdown, you can use a rollup or formula depending on the database setup.
Using a formula with date property works for most cases.
Is there a way I can input those formula without changing the property to "formula" coz I still want the property to on calendar so I can still click the box and show me calendar.
A formula property can be shown in the calendar, I do that in my weekly agenda video.
Not, those date format need to be made by a formula.
@@DannyHatcherTech sorry what I mean is date. when you click on the box under the date property it will pop up a calendar to pick a date.
but if you do this using formula.
and wanted to change the date that has been entered through formula. the pop up calendar doesn't appear. you gonna type it manually.
@@ChibiKeruchan if the formula references a date property you change the date property and the formula automatically updates.
how to add notification to the formula date type?
I stopped using Notion 2 years ago but you couldnt then and i dont think you can now. It needs to be a date property
@@DannyHatcherTech what if this date has to be calculated (coded) via formula property, I guess there is no solution am I right?
@@salahalfiky the formula property didnt have notification options so no 🤷♂️
How do i just input the time? Not current time, but custom time. Like I want to put today that I went to sleep last night at 01:20. How do I do that? Thanks!
You can do that natively without formulas. When you go to into the date property there is an option that says "include time" and that lets you select a timestamp 😁
@@DannyHatcherTech Yeh that's fantastic, but I want to omit the date from it. Is that doable?
@@RoZaxTheGreat if you just want the time, you can write it as a number or text property. It depends what you want to do with it.
Essentially, why are you tracking it, and what will it be used for...
@@DannyHatcherTech thanks for the reply.
I want to write time slept, time woke up and then a formula to calculate hours and mins spent sleeping. But I dont this is possible?
@@RoZaxTheGreat you can do that with number or date properties. It would just change the formula you use. Datebetween or subtract 😁
I want to make a data base of daily activities against each date of the year . How to enter all the dates of the year in one go ?
Import an excel spreadsheet 😁
@@DannyHatcherTech That was smart ! Though mean while I was searching and stumbled on notion pop
↯ Is there a way to have the equation appear blank if there is no specified time?
By adding "" in the part that says there ia no time.
You may need to add it after a format or ToNumber function 😁
@@DannyHatcherTech ↯ I'm a complete equation noob, so that's gone straight over the top of my head.
Right now I have:
formatDate(prop("Date"), "LT")
Appreciate the help Danny!
@@madebypanic ok so you need to put that in an if function.
If(the date property is full, true [ put what you have], false [""])
@@DannyHatcherTech ↯ I feel like I'm trying to do surgery with a hammer haha.
if prop("Date"), true formatDate(prop("Date"), "LT"), false "")
This is probably completely and utterly wrong on so many levels haha
@@madebypanic close.
if(empty(prop("Date")), formatDate(prop("Date"),"LT"), "")
so if the date property is empty put the date stuff if not put nothing which is the 2 " marks.
Hope that helps 😁
Hello, Can you please help me, I wanna know the formula that shows the week of the month in notion ( for example Sep 12 = week 2) or April 23 = week 4, in general shows the week number based on the current date, I have a formula that shows the week of the year , but I don't need this. Thanks
Hi, there is not a natural formula in Notion that lets you do that. You would need to play around with the dates as each month has a different amount of days and starting points.
I will put it on my list of things to work out but I can't currently think of a solution.
Sorry. 😁
@@DannyHatcherTech Thanks mate , I have another question, Is it possible to assign a formula to just one row in notion?
for instance row 1: prop("A") * prop("B") * 0.094
and using another formula to row 2
prop("A") * prop("B") * 0.05
when I change the values all columns data change!
@@editsbyzed not inside the database. The formula will be applied to every column (property). You would need to put in queries into the formula to account for it.
You could bounce the information using a relation and rollup, then do the calculation and bounce it back with the same process.
Very dependant on how the databases are set up, and what criteria the calculations need.
Hope that helps 😁
@@DannyHatcherTech I have to figure it out , it's beyond of my knowledge :D
@@editsbyzed Ok, I have a couple of templates that use this idea. I believe they are finance based.
Feel free to look around, learning is fun 😁
How do you get the RELATIVE date ? theres an option when you have date field to show relative - however I cant find how to do that with the format date option. Also since you cant just reference a column that has a date with the style because it grabs that original date property im stuck... anyone know how to do this ?
Ileft Notion 2 years ago but the relative date option was clickable whereas the other dormatting options required a formula, sorry I cant be more help
@@DannyHatcherTech thanks for the reply. Yeah I guess the only way is to manually code it yourself.
How do you show RELATIVE formula? Can't believe nobody tells it online. I want a formula that's "DATE: " + formatDate("Date"), relative but there's no way to do it. I want it to say "Date : today 1pm" or "Date: tomorrow 6pm"
I have stopped using Notion and use Obsidian now but if the formula's work the same, the relative function is a setting in the date property.
If you are using a formula you would need to create the relative setting in the output you display.
But the point is you can't select and change the date in the Formula property so you would have to keep two properties visible, the date property where you make the changes and the Formula one where you see it the way you want. This kind of defeats the puprose. If I'd like to see the date as 13 Nov instead of November 13, 2022, then I''d actually be seeing both and having two columns in my database which is even worse than the original too clumsy November 13, 2022.
Your your changing the date using a property yes, but you could change the date in a calendar view, timeline view or using any auto filter that alters the date property meaning you would view the formula only.
All depends how you change the date property 😁
Action date selected from 02 March 2023 to 10.03.2023 but when filter on 3rd March by date, than it’s not showing.. why is it so??
Sorry I stopped using Notion over 2 years ago. My guess is that the date you entered is specific so you would need to filter for on or before the 3rd.
@@DannyHatcherTech just was curious to know, that was the reason you stop using notion.. is Notion worth to use?
@@arpitdoshi I did a video about it on the channel. Basically for my use case (research, learning, knowledge management) Obsidian is just better.
If your interested to see how to prioritise your tasks automatically check out this video next: ruclips.net/video/BWfkjC8duI0/видео.html
They must have changed the way this works. Bc I followed verbatim and keep getting an error message.
Notion has had lots of updates.
I wish it could display "NOW" as date. It's not the same as having the current date.
That would be nice.
I moved to Obsidian for more flexibility. It lets me do things like that 🤷♂️
@@DannyHatcherTech Ah cool, I've tried that briefly, will check again! I was also thinking it would also be nice to be able to add "?" or "N/A" as date, which is different from just having it blank 😅
@@zacalves aha yeah.
I do my task and project management in Morgen then have granular tasks in Obsidian.
Do you know how to modify the start and end date in timeline?
I think you can set them as dares used and drag pages back and fourth for edits.