I track employee timesheets using subitems and dynamic views. Each subitem represents a day of the week for a given week# (which is the main pulse). I need to be able to keep separate records from Monday for various legal reasons, but it’s a big help being able to export the time tracking column alone, to Excel.
However, when I export the time tracking column to Excel, the export ignores any filters I have applied. So if I have filtered by all time tracked in Week 24 and Week 25 (For bi-weekly time reporting) and then I export the subitem time tracking column, I get an export with ALL weeks 1-25, and it produces the data all out of order. It’s a very searchable export, so it’s not useless as it is now, but it’s very time consuming to filter out the several thousand rows created by the volume of unneeded data.
I want a feature that allows me to export an Excel doc from the tracked time info, of all sub items within the boundaries of what I have filtered. For example, If I filter by week 24 and week 25, I want an excel doc that only considers the subitem time tracking for week 24 and week 25.
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.
Howdy. My team actually created a custom coded solution in this domain. 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.