Pulling in data from multiple sheets
I just finished making a time sheet project that works well but now I need to pull data in from the filled-out sheets into a summary.
- Time Sheets
- There will be single-digit numbers of time sheets each month
- Managers fill out time for their employees buckets into projects and finance codes.
- Reporting Sheets
- One for each month
- Pulls data from each time sheet
- Need to have totals for each finance code per department
I have attached example screenshots for the two sheets. This doesn't have to be completely automated (I don't mind tweaking a few things one a month) but I'm at a loss how to pull this many dimensions of data from multiple sheets and get them into the summary. Let me know if there are any other questions.
Answers
-
Could you plug in some sample numbers so we can visualize how it all needs to come together?
-
All of the numbers in a row in the time sheet will add up to 1 (100% effort for a given employee). Then the report should sum the effort numbers for each bucket (Internal, ABC, etc.) that were recorded for all employees in each department.
So if they reported that all HR employees spent 1.5 effort on Internal and 2.5 on Internal those would show up in those cells of the report.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives