I have several contractors who are working on different projects but the projects themselves do not have a project board with items to log time against. Therefore I want the contractor to be able to select which project (item) they want to log time against from the list of projects they are assigned to.
When I look at the Projects board with several projects listed, I want to be able to see the round up of time logged across everyone’s timesheets against that project
The key goal is that the user has one board for all projects to log time in the same way, but the automations take the time off the relevant project. It would also be great to have a breakdown per user.
This is a limitation of Monday’s native time tracking. It’s built around logging time per item, not from one shared timesheet across projects.
A simple workaround is one central timesheet board where contractors log time and select the project from a dropdown or status column. Then use automations or Make/Zapier to push that time to the correct project item. From the Projects board, you can roll everything up with mirror columns or dashboards to see totals per project and per user.
Not fully native, but it keeps logging easy and reporting clean.
I believe Work Perfect has an excellent app for time tracking. It shows only the tasks the logged in person is assigned to. Search for TimeSheet Pro in the marketplace.
Hello
Use one Projects board and one shared Timesheet board.
Projects board
Each item is a project. This board is only for reporting and totals.
Timesheet board
Each item is a time entry. Contractors log time here using a Person column, Date, Time Tracking, and a Connect Boards column linked to the Projects board.
Contractors select the project from the connected boards column when logging time. You can restrict this column so they only see projects they’re assigned to.
On the Projects board, use Rollup columns to sum all time tracked from the Timesheet board. This automatically gives you total time per project across all contractors.
For per user breakdowns, use dashboards or filtered rollups grouped by person.
This keeps one simple logging experience while giving you clean project level and user level reporting with no heavy automations needed.
Dr. Tanvi Sachar
Monday Certified Partner, Monday Wizard
You can achieve this by using a single timesheet with a project dropdown. Contractors select the project they’re working on, and automation pushes each entry to the correct project for roll-up totals.
Most platforms let you aggregate hours per project and also break down by user, so you get both team and individual views. Just ensure the automation reliably updates project totals when entries are edited, and your single-sheet approach will stay accurate and simple for users.
Single sheet with dropdown sounds nice until someone forgets to change the project and screws the totals. Linking entries directly to projects is safer. Fewer silent errors.
I had this challenge and also some of the requirements mentioned below. I needed to also pull a charge rate for a person assigned to a project (which could change over time) to feed into billing information. I ended up with Project Board, Rate Board, Timesheet Board, and used a generated look-up key to retrieve the correct rate for the correct person/project and calculate from the submitted timesheet the changes to the running totals on project. There are some great suggestions on here, showing the many ways to achieve the same outcome - I will be exploring some of the other suggestions come the new year.
