Need a Repeat Offenders report

  • 5
  • Idea
  • Updated 5 months ago
  • Not Planned
Want to monitor who is submitting their timesheets late so disciplinary actions can be taken.
Need to see after they are already submitted how to find if they were past the deadline. this could be a weekly or monthly report. 
Photo of Nicole

Nicole

  • 7 Posts
  • 0 Reply Likes

Posted 3 years ago

  • 5
Photo of Naveen Chander

Naveen Chander, Product Manager

  • 39 Posts
  • 12 Reply Likes
Official Response
Hello Nicole,

Though the Repeat Offenders report is not available as a separate report in Gen3, I believe it should be possible to pull out late submission info by using a custom column/formula using the Timesheet Day report template. The idea is to use a custom formula to compare whether the Submitted On date is greater than the Timesheet Period End Date or Due Date as the case may be.

Running this report for a 1 month period would show us all the timesheets for a user that were submitted after the Due Date. This column can be set to Sum, so as to see the overall count of the no. of timesheets in a month that were late. 

This report can then optionally be exported to Excel for further manipulation of the data.

A sample report could look like this: 


Please let us know if you'd like to get additional help with setting up this formula, and one of our Support specialists would get in touch to assist you further.

Thank you,
Naveen