Forum Discussion
How to make a Team Schedule tracker
To explain my problem, let me give you all a basic structure on how I receive the data. Please note: I really don't want a complete solution but a direction I can go. All of this is too much of ...
Please check now
parthsahay Thanks, that worked. But now I don't understand what you want. Based on the data in the file, how would you want to summarize it if you had to do it manually? I.e. without formulas.
- Alright. If I had to do manually I'll take each session details and create a timeline for each tutor. In each timeline I have to put the class timings and free periods separately. For example If I'm having sessions at 3 4 and 6 pm respectively, I'm free at 5, 7, 8 and 9 pm and in case of emergency I'm available for the reassignment or as a backup. What if we create a sheet or table (Pivot table if it is possible) for the tutors in a list of my team from the list of tutors of the whole Organization to track and reassign the session as per requirement. Hope this helps!!
parthsahay Still not clear in my mind what you want, but perhaps the attached file helps. If not, can you create a "timeline" for a few tutors manually?
Note, I inserted a column for the Session Start Time.
- Hey, I saw a pivot table you made with respect to the timings. It was very close to what I want. All I want to change is to add the whole timeline from the start of the day to the EOD in terms of Yes/No or 0/1 as in available or not available respectively.
Link is given below:- https://docs.google.com/spreadsheets/d/18W7ou_FBQ8wHTXyiCQjaBkWE6WJkamsQxQlIFrRz3WE/edit#gid=464510138