Creating training Calendar
I am currently trying to create a sheet to track who our trainers are currently working with. Currently have 15 trainers, but the team will grow larger in the next few months. Each trainer can train 2 employees at a given time. Employees are trained for 2 weeks.
Ideally, I would like a form that someone can request training through, the training can be approved/denied by the training coordinator, training coordinator looks at the calendar to chose the start and finish date, and then that populates into a calendar. The calendar should send some sort of error when the coordinator tries to book a trainer for more than 2 employees at a time. Calendar should also be visually appealing for upper mgmt.
Any suggestions? I've made a form, and a rough draft of the calendar, but it's not meeting all the needs.