We are a study abroad center and currently use Smartsheet for our class schedule, which works well to combine information between our different sheets. However, when we need to have a more visually effective class schedule (e.g., to verify potential class conflicts, find an empty spot for an event, or simply for distribution among faculty, staff, and students), we have been using Excel because, so far, we could not find a system to view things as we wanted through Smartsheet. I am asking for a product enhancement because being able to do everything through Smartsheet would be much preferable rather than having to manually build a template on a different system.
Through the Smartsheet Calendar App, we tried to build the Smartsheet Class Schedule Calendar featured in the attachment. However, the result attached doesn't fulfill our needs:
- Could the Smartsheet Calendar App allow for sub-columns like Excel? In this case, my primary columns would be the days of the week and my sub-columns for each day would be the classrooms.
- Could the Smartsheet Calendar App allow for grouping by time? Instead of having classrooms listed on the left, I would rather have the times, so that separated blocks can be created for each class in each classroom depending on the length of the class, in correspondence with the starting time and ending time shown on the left (see attached Excel view).
When I look at the Excel file, I can see immediately for any given day of the week, which classroom is busy when and when it is free. I would like to have the same capability through the Smartsheet Calendar App.
Thank you for your help!
Anne
