Creating training Calendar

Hi All,

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.

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!