# Weekly timesheet & Workload **URL:** \ **Category:** Ask the Community\ **Created:** [November 11, 2022, 11:38am UTC](https://connect.superhuman.com/t/weekly-timesheet-workload/35269 "2022-11-11T11:38:22Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Omar\_Mhammedi](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/omar_mhammedi/32/30387_2.png) [@Omar\_Mhammedi](https://connect.superhuman.com/u/Omar_Mhammedi)\ **Post date:** [November 11, 2022, 11:38am UTC](https://connect.superhuman.com/t/weekly-timesheet-workload/35269/1 "2022-11-11T11:38:22Z")
Hi Everyone, i’m new to coda, and i’m trying to replicate some tools i use in other project management software like Wrike or Clickup. While i’m still learning, i would appreciate if you can give me some pointers/directions or direct me to some template to learn from, to do thoses 2 functions : 1- An user specific weekly “Timesheet” that can list all tasks “charged” during that period for an and hours can be added/modified/deleted from a single view like this example : ![8ad29ce77c1cce7062c3c64e6b6e5660](https://global.discourse-cdn.com/coda1/original/3X/b/3/b38e62409bee82df0dbe7d44ef9dce3a946ae5d9.png) 2- A weekly or Bi-weekly workload (hours) that show the workload per day for each person (Based on estimate field in tasks) like this example : ![file-fKklyNtCdQ](https://global.discourse-cdn.com/coda1/original/3X/8/3/8338c84adaf6e5469943c7756137728fbc8662c8.webp) or this one ![Screenshot 2022-11-10 at 2.01.35 PM](https://global.discourse-cdn.com/coda1/original/3X/5/0/50f50df2fd39f83ff25d841b5bcbcc4d69a9b9e6.jpeg) Thanks in advance ---
**Author:** ![Quentin\_Morel](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/quentin_morel/32/31407_2.png) [@Quentin\_Morel](https://connect.superhuman.com/u/Quentin_Morel)\ **Post date:** [November 13, 2022, 9:43pm UTC](https://connect.superhuman.com/t/weekly-timesheet-workload/35269/2 "2022-11-13T21:43:17Z")
> [@Omar\_Mhammedi](#): > > 1- An user specific weekly “Timesheet” that can list all tasks “charged” during that period for an and hours can be added/modified/deleted from a single view like this example : Hi Omar, and welcome to this community !! For your first example, you can set stuff quite easily, find here a **very short** example for you to understand the process - I would create a **people** and a **project** database - A timesheet log database, which is the core of the process - And a **day** database Your timesheet log takes lookup from all the other database, and for each block of work, you create a timelog ![image](https://global.discourse-cdn.com/coda1/original/3X/6/2/622d67b3e14db312828dc6a0afc307f62690b1a7.png) What you want is a cool user display : ![image](https://global.discourse-cdn.com/coda1/original/3X/9/e/9e41f9d771cd5809cf4cc2356c782df2c22b711d.png) - I created control for IsoWeekNumber and user and create a filter view of my timesheetlog, group by day in top, and project in left, showing the time I spent ![image](https://global.discourse-cdn.com/coda1/original/3X/1/f/1fbeb537c9b77edeadf150550194b1cea40b4393.png) Then I create several “summarizing view” t o have the total easily per day and per project ![image](https://global.discourse-cdn.com/coda1/original/3X/0/7/07d66117bc3b10169beb76ebedf3e8b82297e968.png) You can see all of this is obviously dynamic (in this example Omar has no hour entered) ![CPT2211132235-1673x859](https://global.discourse-cdn.com/coda1/original/3X/5/2/52f194b5be1802d720e81c7da70f457904a06479.gif) * * * Please have a play with this embed doc to check the formula (I did it quickly) and come back if you have any further question. Is this process you can easily create the table in your second example, with people (check page 2 in embed doc) ![image](https://global.discourse-cdn.com/coda1/original/3X/4/0/4097e0b455e1191780b9d42b9402223e3dc9ee7f.png) Cheers Q. https://coda.io/embed/r2YWB3wfZv/_sudaK?viewMode=embedplay ---
**Author:** ![Omar\_Mhammedi](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/omar_mhammedi/32/30387_2.png) [@Omar\_Mhammedi](https://connect.superhuman.com/u/Omar_Mhammedi)\ **Post date:** [November 13, 2022, 10:17pm UTC](https://connect.superhuman.com/t/weekly-timesheet-workload/35269/3 "2022-11-13T22:17:50Z")
Thank you so much Quentin, That’s extremely helpfull ! ---
**Author:** ![Quentin\_Morel](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/quentin_morel/32/31407_2.png) [@Quentin\_Morel](https://connect.superhuman.com/u/Quentin_Morel)\ **Post date:** [November 14, 2022, 10:56pm UTC](https://connect.superhuman.com/t/weekly-timesheet-workload/35269/4 "2022-11-14T22:56:39Z")
Hey @Omar_Mhammedi Happy you liked it. I think you now have all the keys to build your own tools that will perfectly fit to your needs ! ---
**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\ **Post date:** [November 17, 2022, 10:57pm UTC](https://connect.superhuman.com/t/weekly-timesheet-workload/35269/5 "2022-11-17T22:57:06Z")
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.