Need a Repeat Offenders report

  • 6
  • Idea
  • Updated 1 year 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 4 years ago

  • 6
Photo of Lingaraj Dharwad

Lingaraj Dharwad, Product Champion

  • 1100 Posts
  • 46 Reply Likes
Hi Nicole,

Thank you for using Replicon community,

We are reviewing your idea.

Thanks,
Lingaraj
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
Photo of Jeanne Bovenkerk

Jeanne Bovenkerk

  • 25 Posts
  • 11 Reply Likes
Would it be possible for the formula be shared here for those of us familiar with using custom formulas in reports?
Photo of Naveen Chander

Naveen Chander, Product Manager

  • 39 Posts
  • 12 Reply Likes
Hello Jeanne,

Here is the formula that can be used with the Timesheet Period template to check for late submissions.
As an example, I have considered the Due Date to be 2 days after the last day of the Timesheet Period. Hence the formula checks whether the submitted date is > 2 days from the timesheet end date. If your Due Date setting is different, you will need to change this (>2) condition as appropriate.

If (IsNull (TimesheetSubmittedOnUtc), "", If (DayDiff (TimesheetEndDate, TimesheetSubmittedOnUtc) > 2, "Yes", "No"))

Hope this helps.

Thank you,
Naveen
Photo of Tony Weber

Tony Weber

  • 81 Posts
  • 12 Reply Likes
Hello,
I'm trying to create a similar report, except I want a formula to tell me how many days the timesheet was initially submitted on after the due date. I don't just want a Yes/No. What would that formula be?
Photo of Tony Weber

Tony Weber

  • 81 Posts
  • 12 Reply Likes
Would it just be "DayDiff (TimesheetEndDate, TimesheetSubmittedOnUtc)"?
Photo of Parth

Parth, Product Support Engineer

  • 1 Post
  • 0 Reply Likes
Hi Tony,

The DayDiff() formula gives us the difference between two days. We can have a check done based on the difference in days of the Timesheet end date and the date it was submitted.

Below is the formula that can be used for the same. You can use most of the Timesheet based templates to configure this report. We would suggest using 'Timesheet Day Template' as it would give you all other relevant information to track users or their supervisors.

Formuala: if(DayDiff(TimesheetEndDate,TimesheetSubmittedOnUtc)>0,"Offender","Clear")

Delay: DayDiff(TimesheetEndDate ,TimesheetSubmittedOnUtc)

The value '0' here can be changed to the grace period you want to provide the users. Based on the current formula if the user submits the Timesheet on the last day, the difference will be 0. If he submits it the next day, the column would show him as an 'Offender'.

You can also change the text result of these conditions. You can have the 'clear' as a blank field as well (""), in which case the column will be blank for users who submit their timesheet on time.
The delay formula will give you the number of days the user has exceeded the submission.

Please let us know for any further assistance on the same.
Photo of Tony Weber

Tony Weber

  • 81 Posts
  • 12 Reply Likes
Is what I'm seeing correct that TimesheetSubmittedOnUtc is the most recent time submitted? I.e., if a timesheet was submitted on 1/15/2017, rejected on 1/16/2017, submitted again on 1/17/2017, then TimesheetSubmittedOnUtc will be 1/17/2017 NOT 1/15/2017?
Photo of Tony Weber

Tony Weber

  • 81 Posts
  • 12 Reply Likes
@parth nudge
Photo of Michael Pearce

Michael Pearce

  • 2 Posts
  • 0 Reply Likes
This reply was created from a merged topic originally titled Summary of Missing Time Sheet - Email Notification.

I need a report that is a summary of people who have not submitted their time sheets by the deadline.  Submitting time sheets is a important part of someone's job, and I need to know who is not doing their job.
Photo of Lingaraj Dharwad

Lingaraj Dharwad, Product Champion

  • 1100 Posts
  • 46 Reply Likes
Hi Michael,



This idea has already been raised and a work around has been provided.
One of the support representatives will reach out shortly to you
regarding the same.



Thanks,

Lingaraj