Timesheets

Logged time by person, team or any field, in days, weeks, months or quarters — with leave and short weeks accounted for.

A Timesheet tab reads the worklogs of the work items in the report and lays them out as a grid: people down the side, periods across the top.

Range

Either a fixed pair of dates, or a moving one: this week, last week, this month, last month, the last 7 days, the last 30 days, this quarter. A moving range means a saved report and a dashboard gadget are right every week without being edited.

Grouping

  • Person — whoever logged the time.
  • Team — from the team map in admin settings. Someone with no team gets a "No team" row rather than disappearing.
  • A field — any user or select field on the work item, so you can total by component or by customer.

Columns can be days, weeks, months or quarters.

Flagging short weeks

Set "flag people under N hours" and anyone below it in a period is marked. The threshold is compared against working time: weekends, public holidays and that person's leave are taken off first, so somebody who was off on Thursday is not flagged for it.

Working days, hours per day, holidays and leave all come from admin settings.

If leave cannot be read, the timesheet says so. Nobody on leave and leave that failed to load produce exactly the same grid, and the difference matters — so RollGrid tells you which one happened instead of showing a confident blank.

Worklog comments

Switch on to show each worklog's comment under the day. Off by default, because it makes the grid long.

Which day a worklog belongs to

A worklog is split at midnight in its author's time zone where that is known, because "what did I do on Tuesday" means their Tuesday — not the site's. Where an author's time zone is not known, the site time zone from admin settings is used. A worklog spanning midnight is divided between the two days rather than landing wholly on one.

The range shown is the range read

If the report loaded a narrower span than the tab asks for, the timesheet shows only the overlap, and the dates at the top say which span that is, rather than drawing empty columns for periods it never read. An empty column that means "no data fetched" looks exactly like one that means "nobody logged anything".

An empty timesheet

Worklogs are found by searching for the work items that have them. If nothing comes back, that means nobody in this report logged time in this range — not that the search failed. A failed search says so separately.