Hello!
We have a scheduling team that is working out of 5 Google Sheets they created to look like calendars - each tab is a new month and each role they schedule has a different Sheet. There are different scheduling rules to take into account with each role type which makes it nice to see them separately. Their current process is an LOA request comes in, they filter through a few of the sheets to place a traveler in that position. They keep in mind things like, PTO, licenses for nurses, and proximity when scheduling. They also want to fill the position at risk of the highest impact first.
This is a lot of brain power and manual work, I want to think through a Smartsheet solution for this team. I am picturing a master sheet with all of the traveler insights and then a report for each role, but I don't know the best way to have their calendar view when one sheet may have 20 different people assigned on one week. I also would like to automate where I can and am tossing around the idea of a prioritization scorecard for writing a formula that will recommend where to schedule people first. Any feedback or ideas would be greatly appreciated.
