I’m looking for some guidance on setting up time-tracking reports across multiple boards for a client.
Different teams currently track time in different ways (some use subitems with time-tracking/number columns, others track at item level). They all manually enter actual time in a numbers column rather than using the time tracker widget, as they find it too fiddly.
I’d like to create a dashboard—or a central board—that brings all of this data together to show estimated vs actual time logged per employee per month, but I’m struggling to get this into a clear, easy-to-read format given the inconsistencies across boards.
Has anyone solved something similar or have suggestions for the best setup?
Even if they’re using subitems with a number column, you can use a ‘mirror’ column on the parent to sum the subitems. Then you can use a dashboard that’s pulling totals from the item levels on all boards.
What about creating a central timesheet board with categorisation and have all time entries coming into a central source. You can also create an automation on each project board when they are assigned it puts a placeholder in there timesheet.
Love this suggestion and thanks so much for the reply.
I had considered this, and would love to have a Timesheet Hub of sorts, which pulls through individual resource time from various boards. The problem I’m finding is that I can’t create an automation that creates items from a subitem level (which is where the resource and time currently sit).
If you have any other thoughts, would love to hear!
This is a great suggestion, the only challenge I still have is that I’d like the subitem details in order to break the ‘timesheet hub board’ down by Resource (people column), which sits as a column on subitem level.
hi @LexiNiccolls ! I’ve run into this exact challenge before - monday’s native reporting really struggles when different teams track time differently (subitems vs items, number columns vs time tracker).
If you want a clean, unified view across all those boards, take a look at Time in Status for monday.com - it pulls time data from items and subitems, even if teams track it in different columns, and lets you build consolidated reports.
You can create a dashboard showing:
estimated vs actual time per employee
hours per month across all boards
detailed breakdowns per task, per subitem, per date
consistent reporting even with inconsistent board structures
It’s honestly the easiest way to normalize messy time-tracking setups across multiple teams.
Thanks so much for the reply. There are quite a few issues I’ve been coming up against now that seem to require third party apps. Monday enterprise licenses are costing my client enough as it is without spending extra on multiple apps, as it all adds up
I feel something like timesheets and time tracking reports should be a functionality that comes as standard.
