Filter to track Timesheet Submission Status

  • 2
  • Problem
  • Updated 2 years ago
  • Solved
Currently we have a report with a custom report that shows us the submission status of the timesheet.  For example: late & pending.  This is done through a custom column which has the below formula

if(TimesheetApprovalStatusCode=2,"Approved",if(today()>TimesheetEndDate,"Late","Pending"))

Even though this does the job of giving us information on which are late and pending. We can't omit any results.  For example:  I don't want to see timesheets that are pending.  It would be great if this could be made as a standard column with auto filter in the reports.
Photo of Deedee Beauchamp-Russell

Deedee Beauchamp-Russell

  • 1 Post
  • 0 Reply Likes

Posted 2 years ago

  • 2
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1560 Posts
  • 108 Reply Likes
Hi Deedee,

Thank you for using the Replicon Community!

Before we proceed may I confirm if you have tried the Approval Status Filter. You can use Approval status as both column and filter. I agree that it does not show you the status as pending or late but you can see the following 4 status:

Open
Waiting
Approved
Rejected

And using this you can see the timesheet with certain status.

Thanks,
Aashnee