Hi!
I need help designing a tracker for team members to track any work outside of their normal daily tasks. I have completed formulas to work out how many hours they have spent on each task and how much of their day they have utilised on each task, but I can’t think of the best way to present all of this.
I was thinking maybe for each member creating a separate tab but is it possible to have a drop down for each day which they select that they can populate which then generates the daily, weekly and monthly stats on seperate tab which I can then filter by each member?
Any suggestions and help will be greatly appreciated
I need help designing a tracker for team members to track any work outside of their normal daily tasks. I have completed formulas to work out how many hours they have spent on each task and how much of their day they have utilised on each task, but I can’t think of the best way to present all of this.
I was thinking maybe for each member creating a separate tab but is it possible to have a drop down for each day which they select that they can populate which then generates the daily, weekly and monthly stats on seperate tab which I can then filter by each member?
Any suggestions and help will be greatly appreciated