Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Employee Hour Reporting

Topic Labels: Base design Data
259 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