In office tracker w/ Calendar view
I'm challenged by trying to come up with a simple, efficient and creative method to create a sheet(s) that I can use to track approximately 20 or so colleagues on what days they'll physically be in the office. We're moving to a 3/2 flexible work schedule that allows you to be remote 2 days of the week.
I'd like it to be Form driven, where a colleague can just pull up a form for the coming week or month and input their planned days in the office. I'm familiar enough with Smartsheet to create the Form from the sheet, I'm just struggling with the most efficient way to get this into a sheet.
I'm hoping to aggregate the data into either one report or dashboard that I can then publish and expose in MS Teams as a viewable calendar that shows which colleague is planning on being in the office on any given weekday within a month.