Time tracking export

Platform discussions
1

Hello,

i would like to have an export based on time tracking column, as stated here : I need a solution for a pivot table for time tracking (using TIME TRACKING COLUMN!) , i do not want another tracking solution since our reporting is made directly in monday tickets.

So our developers use the time tracking column but when i use csv export of one of my sprint :

  • i do not have the name of the developer who logged the time
  • if multiple developers logged some time in the same ticket, this is not visible in csv export

I saw i can have this detail if i directly export the time tracking column but in this case i lose all the other informations.

Thanks very much,

1 Like
2

hello,

does anybody have some hints on this ?

Thanks !

3

@Atobi

What types of solutions you are open to?

I have used a Make scenario to expand time tracking column data to a time summary board. A similar approach could be used to export data to a sheet or subitems or other.

Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you?
Schedule a 1-on-1 Tutorial Session

4

thanks @JCorrell for helping. I’m not sure to know what is a make scenario. Export data to a sheet
can be ok for us too.

Thanks again

5

Hi @Atobi ,
Can I suggest another solution for you? With Tracket you can track time on items and subitems with multiple people. We also have a csv-export available with the user that logged the time.

You can find more information about Tracket on the marketplace: https://monday.com/marketplace/10000017

BR,
Elise

6

@Atobi

You can find out more about Make at the linked page in my signature above: What is Make & How can it help you?

7

Hello Jim. In which video do you cover this? I’d love to check it out.

8

@lily7emotion

I do not currently have a video related to the time tracking column.

9

Hello community, is there any sample about time tracking export for multi-board, sub-items ? We are trying to automate the “timesheet” monthly report from people working in multiple projects and recording time tracking both in parent tasks and sub-items. Thanks!

10

Hi @JCorrell , how do I see this solution please?

11

@samjtaylor @carlos.oliveira Analytics & Reports by Screenful allows reporting time tracking data both on top level items and subitems. You can learn more from this guide: Creating charts based on time tracking data - Screenful Guide for monday.com

You can also create reports based on this data and schedule them to be sent daily/weekly/monthly to selected recipients.

12

@JCorrell @sl1nna @samjtaylor @carlos.oliveira @lily7emotion
Advanced reporting board is now available for time trackers using Smart Timer and Team Tracking app which has the same look and feel as the native monday.com timer. With an excel export option!

We had the same pain point with our service based business, detailed reporting is so important, so we got our dev to build a solution which we have now released to the monday.com marketplace.

We also built in the ability for the team to see LIVE who is recording time on what, this helps us to manage our remote team and re-delegate work as needed.

We have only recently launched so if there are any tweaks that would help it better suit your business feel free to add to the live chat and we will see if we can roll it out in the next update.

13

My team actually created a custom coded solution for this. It’s a board view that allows you to choose time tracking columns on multiple boards to pull excel reports from where the time is grouped by person/board. Maybe it’ll help some teams out. It’s a private app and just a prototype for now but you can install it with this link. Let me know if you find it useful.