Hi guys, newbie alert
I’m trying to build an employee scheduling doc. Basically a list of tasks with due-dates and employees assigned to it. I then also want to create an overview of total hours scheduled per employee per week. And that’s where I’m stuck…
I’ve created a test doc so you can see what I mean:
In the table
Hours per employee I’ve not been able to calculate the total hours assigned to an employee directly (probably doing something wrong?!), only via first adding a column (
tasks) which lists the individual hours (duration) of the tasks assigned to that employee, and then in the next column (
hours) calculate the sum of these hours.
Problem: the sum of hours needs to be filtered by week number (matching the filter control
Filter Tasks Week # above the table
tasks). Right now it’s showing the total from that employee for all weeks combined.
2nd problem: I then want to specify these total hours further per weekday in the corresponding columns.
I’m sure this is relatively easy to do, but I really need someone to point me in the right direction