Help

Employee Hour Reporting

Topic Labels: Base design Data
111 1
cancel
Showing results for 
Search instead for 
Did you mean: 
bssmaster8
4 - Data Explorer
4 - Data Explorer

I have a group of freelancer reporting weekly on how many hours they worked on various projects. Im looking for a way (either through a view or interface) to see a report of how many hours are worked, by each employee, on each project, per week.

 

1 Reply 1

Hmm try creating a formula field that outputs `[EMPLOYEE NAME] - [PROJECT] - [WEEKNUM YEAR]`, and paste that into a linked field to a new table where each record represents the hours worked in one week for one employee for one project.  This'll link everything appropriately and let you create a rollup field to sum up all the hours like you want