Hi
I'm trying to create a spreadsheet that allows me to log the time teachers are spending on tutorials etc with individual learners
I have a sheet with various drop down lists (teacher name, faculty, activity, time spent). I also have a date picker for each cell in a given column. One column is for adding learner names.
Columns on sheet 1 are:
I want to collect certain data from this log in 2 new sheets. However, I want to allow staff to edit each 'learner row' by adding new dates and times when they see that learner, while keeping running totals on sheet 2 and 3
For sheet 2, I want to collect data about the learners. I would want:
Learner name, activity, total time seen.
For sheet 3, I want to collect:
lecturer name, activity, total time spent across all learners (staff will see multiple learners and complete different activities)
So, is there a way I can make so that the date and time columns can be changed, while not losing the data entered previously (so total time seen can appear on both learners and satff info on the other pages)?
Thanks
I'm trying to create a spreadsheet that allows me to log the time teachers are spending on tutorials etc with individual learners
I have a sheet with various drop down lists (teacher name, faculty, activity, time spent). I also have a date picker for each cell in a given column. One column is for adding learner names.
Columns on sheet 1 are:
lecturer name | learner name | faculty | activity | date | time spent | |
(drop down) | (drop down) | (drop down) | date picker | (drop down) |
I want to collect certain data from this log in 2 new sheets. However, I want to allow staff to edit each 'learner row' by adding new dates and times when they see that learner, while keeping running totals on sheet 2 and 3
For sheet 2, I want to collect data about the learners. I would want:
Learner name, activity, total time seen.
For sheet 3, I want to collect:
lecturer name, activity, total time spent across all learners (staff will see multiple learners and complete different activities)
So, is there a way I can make so that the date and time columns can be changed, while not losing the data entered previously (so total time seen can appear on both learners and satff info on the other pages)?
Thanks