Use case for timesheet in Smartsheet
I have the following use case that I would like to implement in Smartsheet but I am not sure what is the best option :
- I have a sheet for each employee in my organization, where they are filling incurred time (in days) for each month for each project they are working on.
- I have a master sheet with all the projects and ressources where I would like to compare incurred and planified time at year level for each resource. For planified time I just take data from the projects sheets so it is quite easy, but for incurred time I need to take the sum of incurred time from each resource (that means from each sheet).
The only option I found is to put a formula that verifies who is the resource and then take the incurred time from the specific sheet of the resource. But that means I will need to do that for each resource of my organization (20+) so the formula will be very long and complex.
Another option would have been to put all the incurred time for all the resource in one place (a report for example), but I after that I cannot do formulas that take data from a report..
Do you have any ideas or suggestions about this ?
Thank you very much for your help !