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 logic which I'm unable to think so asking for some genuine help.
Statement:
In my organization, daily morning we receive a class schedule sheet containing the tutor email id, Class timings, class link, channel ids etc. each tutor gets minimum one and maximum 5 sessions daily as per availability and cohort. Now there are many different teams of tutors under different managers. What I want is to fetch the data from the central sheet, sort my team out and see when the rest of my team members are available or do not have session while remaining members are available. I have used lookup and count fxn to fetch the unique IDs and number of session each tutor received but how to present the class timings and time of availability, or to say in easier words, when according to the schedule, these tutors are available so that in case or replacement or reassignment of class they can be reached as per tracker and we do not have to call 100s of tutor one by one just to ask them their availability. This tracker should also show if there is no tutor name fetched in the central sheet then that tutor is either unavailable or on leave. or how to create a list of present tutor on that day would be a much better option. All of this is too much of logic which I'm unable to think so asking for some genuine help. A sample sheet is attached in the link.
https://docs.google.com/spreadsheets/d/18W7ou_FBQ8wHTXyiCQjaBkWE6WJkamsQxQlIFrRz3WE/edit#gid=1486209935
8 Replies
parthsahay Can't access the sheet. Since you have Office 365, please try sharing via OneDrive.
- 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.
