Видео

how to align text to center within the table?

Thank you for your hard work on improving your Notion Time Tracker, this makes it much better. Also thank you for making a template to purchase at a great price for those of us who are not as proficient at Notion.

New subscriber here 🎉 Love your video! Curious if this is possible: I have two databases: 1. Task Database: Tracks tasks with a relation to the Weekly Database. 2. Weekly Database: Contains 12 pages (Week 1, Week 2, etc.). I’m trying to create a button in the Task Database that: • Duplicates a task when clicked. • Updates the relation to the next week dynamically. • Example: If a task is related to “Week 1,” the duplicate should relate to “Week 2.” • If the task is related to “Week 2,” the duplicate should relate to “Week 3.” Is it possible to achieve this using the custom formula option in buttons? If so, how? Thanks!

thank you so much for this tip!

Question for you, I have templates for reoccurring tasks. If I use this for my reoccurring tasks, is that going to create a problem for the task database formulas and the timesheet database since the name of the task is the same? If so are there any easy solutions to that problem?

Awesome.

Thank you. New to notion, and this helped so much, not just regards to time tracking, but also using map function in calculations!

@Jolono Many thanks. Just watched the the previous video and that is rolling up the time taken on a project. What I am trying to do is to have the project and client details within the time database so that I can check what time has been taken on a project or client for a certain time period, weekly or monthly. I would roll up the total like you have done onto the project record. Also for a client you might want to see what time was spent on various projects of theirs over a week or month. How can I achieve this, I guess I am saying how can I get the project and client details into the time database record.

Excellent video, many thanks. I have a question though. You are monitoring the time against a specific task, Design Logo or Write Blog. They might be part of a project, could also be related to a specific client. How do you get to record the project and client when you are writing the record in the timesheet database? Can you pull the information into the task when it is created and how would you do that. If you have that info then you could analyse all time spent on a particular client or project for a given time period, say week or month. This is what I would like to do. Any ideas gratefully received.

Idk why that didn't work for me :( but this worked: if(prop("Sales") > 10, "Above Target", if(prop("Sales") < 5, "Below Target", "On Target"))

Thank you for this, this is exactly what I was looking for!

Thanks for sharing. How do I add gridlines for better readabillity? (like you can in Excel sheets and Word tables)

Thank you very much for the formulas on your blog and congratulations! Amazing!

amazing! is there any way to create rules like in excel so if I put "no" in a cell it will automatically set the background of the individual cell red? Thank you!

Hi, seems that when I'm trying to do the button, the option "Now" for trigger is not available in my version. So I end up filling up both start and end when I click my button. Any fix on this?

great tutorial - the best explaining time tracking in notion! thank you so much

Many thanks - especially for those formulas on the blog!

Thank you so much

Great Tutorial. Thank you a lot!

Jo - would appear to be just what I am looking for. Just visited Pop Invoice site. How customisable are the invoices? Need to reflect branding and symmetry with the rest of my brand stationary. Thanks.

Very helpful. Thank you!

Worked for me as of May 11, 2024 thanks!

I luv it. Btw, how can u to calculate the total study time in a day using what formulas. Plzzz help me

Thanks for this! However I'm having a problem with the Total Time. It seems inaccurate. I think it's adding up the total time (minutes) plus the total paused time. The numbers calculated are huge!

Hi Jo! Thanks for the great tutorial! This is so helpful!! Quick question: do you have a formula to calculate the sum of subtasks inside your tasks?

It's seems like when I click unpause every record that has paused status in paused time database update their end prop and projects ar run again but with paused status

How do you do this at the task level vs selecting projects when tracking time?

Love it

Hi from Sydney! Your tutorial is fantastic, so easy to follow!! I'm just having trouble with the last two formulas which I copied and pasted from your blog - Total Time in projects spreadsheet (error reads Function if expects 3 arguments, but only 1 were provided. [0,37] Total is not defined. [5,10] minutes is not defined. [17,24]) and Total Time in timesheet database (error reads Function if expects 3 arguments, but only 1 were provided. [0,37] Total is not defined. [5,10] minutes is not defined. [17,24]). Are you able to help please? Thank you!

Todos os vídeos que eu vi explicando como fazer um time tracker no notion eram muito complicados, obrigada por fazer algo simples de entender e perfeitamente funcional, era exatamente o que eu procurava🙏🙏🙏 você é maravilhosa!!!

at 11:40 time stamp i get a "Cannot do math on number and array. [12,48] Cannot do math on number and array. [53,85]"

search for 'Time Tracking based on sessions' if you want to find the template

Excellent demonstration! I attempted to build a pause button myself and I was way, way off.. thank you so much for showing how it's done. It wasn't what I expected. The third database 'paused time' database was really smart idea!!

Has anyone managed to rework these formulas to fit with the new notion syntax? Great tutorial, easy to follow apart from the formulas that don't seem to work anymore.

amazing video! is there a way to do the same thing but for "last week" instead

Thanks for working on this, but I am afraid it just doesn't seem to work. I have set it up three times, thinking I got something wrong, but each time I end up with minus minutes in my projects database, and the times keep doing odd things - one moment they say I have 20 minutes logged and the next some different time. The time on a single complete record also does not seem to be the same as the time I get recording the same time on a stopwatch, indicating the timesheet is somehow not recording the time correctly. Do you know why this might be?

Notion formula syntax changed. Time Paused Formula looks like that now: empty(prop("End")) ? dateBetween(now(),prop("Start"), "minutes"): dateBetween(prop("End"),prop("Start"), "minutes")

I can't do it because of notion new formula update. please help with new tutorial!!!! 11:54 is too difficult to do in new update i can't even map out the properties.

I can’t thank you enough for providing this template and tutorial. I've been searching for a way to utilize Notion for tracking my time and generating time reports to help me visualize how I allocate my time and maintain a balance between work, family time, screen time, and more. After days of searching without much luck, I stumbled upon your video. By using your template, I only had to replace 'Projects' with tags (such as work, family time, etc.). The automatic creation of tags in the secondary database when inputting them into the primary database is exactly what I've been dreaming of! There's no need to enter them manually beforehand. While I'll need to make a few small modifications to align it with my specific needs, I believe I can achieve the desired outcome. Thanks again!

Hi @Jolono i already followed the code you provided in the minute 11:56 , but in my notion have error "Cannot do math on text and number. [29,87] End of input expected. [520,521]". so could you help me please about how to fix it ?

Oh my gosh, i finally found someone who has an easy formula for the HH:MM format. Thank you! Your blog is so helpful!

the Formulas at notion changed... I cant add the Formulas anymore

Please keep making tutorials! You explain everything so well ❤

Amazing stuff. tested it and it's working great!

Great tutorial, although the method of keeping track of pause time doesn't make sense to me. Why not just keep track of sessions and add all the session times of the task/project. Create a database called time tracker with the usual "status", "start time", "end time" and "Total Time" calculated as in the video, then add a relation to the task table called "related task". When the button of start or unpause is clicked, create a new item as a *session* to the time tracker table with the "related task" set to /this page/ and "start time" set to /now/. With the pause and end button, modify the last open *session* by filtering on empty "Total time" and set "End time" to now (making "Total time" not empty anymore). In the task table set a roll up property to the relation you made earlier with the time tracker table and get the sum of the "Total time" property. This way the total time is always the sum of the sessions you worked on it because it only counts up the ones with the "related task" set to the task name of your current entry. This works because only session is active at a time, you have to pause and unpause when working on other tasks. You can also edit the status of the current task simultaneously with the button from "not started" to "active" to "in progress" (and back to active) to "finished". Tracking "active" sessions instead of "pause" sessions seems much more logical and efficient to me, also more relevant information is provided, when and how long did I work on it instead of when did I *not* work on it.

The final equation for calculating total time isn't working for me, either saying "minutes" is not a number or that there aren't enough arguments for the if statement. I double checked how I entered things, double checked the dependent fields, substituted a simple if statement piece by piece, so weird. Going to continue troubleshooting, not sure what's going on for me

Thank you !

this is amazing, thank you so much.

Love this - I actually want to track time by phase - Im thinking based on your example I could just add a property in the timesheet database for phase and then create rollups for total time per phase at the project level does that make sense?

Thank you for an amazing tutorial. Is there a way to track time for multiple projects? For instance, work; read; etc...?