Filter and export timesheet | Zoho Sprints Help

Filter and export timesheet

The filter and export capabilities of Zoho Sprints enables you to efficiently view and use the logged timesheet data. You can:
  1. Filter the log hours to view select data.
  2. Export the log details as a file.
  3. Copy data to clipboard and paste in on a sheet to view as a table and save it as backup.

Filter log hours

The advanced filter mechanism allows you to easily find what you're looking for. You can apply filters to the logs of particular log types. There are two types of filters: Quick and Custom filters. Quick filters are the in-built filters that are based on the various attributes of projects. Whereas, custom filters equip you with AND/OR conditions to create your own criteria pattern. You can save the filter criteria and reuse them to avoid the rework. Click here to learn all about filters.

To filter:
  1. Go to the Timesheet module.
  2. Click the filter icon at the top.
  3. Select Quick or Custom filter.
  4. Select built-in filter criteria or define your custom criteria.
  5. Apply the filter to view the epics or work items matching that filter criteria. 

Export logs

You can export the log data in an xls or csv file and download it to use outside of the application.
  1. You can apply filters to export select data.
  2. You can access the exported file in Export History.
To export timesheet:
  1. Go to the Timesheet module.
  2. Click the ellipsis icon at the top. The dropdown menu will appear.
  3. Select Export. The Export Filter will appear.
  4. Select the required file format.
  5. Define grouping if necessary.
  6. Select the fields that need to be exported.
  7. Specific Recurrence Type to set up scheduled exports.
  8. Enable Header to assign the field names as headers for the columns.
  9. Select the filters that need to be applied or create custom filters. Learn more.
  10. Click the Apply & Export button. The export will be initiated.
  11. Click the ellipsis icon and select Export History in the projects menu. The exported file will be available in the Completed Export tab.
    1. Completed Export lists the Date, Time, and File Name of your export. View the export details and, if applicable, the recurrence details of the file.
    2. Active Export lists all the files that are active and scheduled for export.
  12. Click the file or the Download icon to download the file.