I'm currently using two lists, one stores tasks [Task List], the other stores the hours worked for completed tasks [Time Sheet List]
When a user marks a task as complete, it creates a corresponding Time sheet entry in the Time Sheet list.
I'm currently trying to group time sheet entries so that I can calculate the total hours an employee has worked that week.
I've tried creating a calculated column that assigns the week number based on the date, then group by that week number but the syntax is proving difficult.
Any help is greatly appreciated.