Summary:
I would like to setup a report in Web TimeSheet to show time off taken to date and future dated time off as separate columns.

Resolution:
The only report in Web TimeSheet that can be used to display time off taken to date and future dated time off as separate columns is Time Off Taken report. You can configure the report by including custom columns. Please find below the instructions to setup the report.

  1. Open the Time Off Taken report.
  2. Click the Settings button within the report.
  3. Scroll down to the bottom of the report and click the Add button under Custom Column.
  4. Add a custom column by name “Future Time”.
  5. Insert the formula If(StartDate < Date(2011,02,01),0,TimeOffDays).
  6. Add another custom column by name “Already Happened”.
  7. Insert the formula If(StartDate >= Date(2011,02,01),0,TimeOffDays).

If you want the report to display time off taken to date and future dated time off as separate columns, you can include today’s date in the Date field in the custom columns shown above.

Once you create the report, ensure that the Summary option is summing the columns.