Hi,
I need to compare the hours allocated to the hours actually worked, through timesheets.
For this I am using a spreadsheet to aggregate all the data from timesheets in order to extract metrics of hours worked by time and in which projects. This time worked on projects would be compared to the time allocated to the employee. However, the limit of 5000 lines is being a big problem to me.
Another way to aggregate all these timesheets would be to use reports, however formulas cannot be used in reports and I cannot use your data in formulas in another spreadsheet.
How could you do that without having to create multiple spreadsheets?
Fig1. Project planning. In the "Codigo" column I have an identifier for the activity and in the "Horas Apontadas (h)" column I have a formula that calculates the sum of the employee's appointed hours in the activity.
"Horas Apontadas (h)" formula example: =SUMIFS({database of hours - duration}; {database of hours - member}; Member@row; {database of hours - activity}; $activity$@row)
Fig2. Timesheet. In the "ATIVIDADE" column, the activity identifier must be inserted.