Has anyone set up a staffing calendar in Smartsheet

Mindy Schneider

I would like to see how other's have used Smartsheet for a staffing calendar. We have a 24-Hour staffing model with multiple shifts, currently using Excel for setting up staff schedules. I would like to shift this to Smartsheet to allow for some notes and comments and more features, however, I can't really figure out the best way to set this up. It would be awesome if I could set it up to be viewed in Calendar view but I'm really struggling with this.

If you use Smartsheet for a staffing calendar would you be willing to share any screenshots? Thanks!

Bassam Khalil

Hi @Mindy Schneider 

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question. and if you like share a copy of the excel file and i will try to create it for you.

My Email for sharing : Bassam.k@mobilproject.it

Mindy Schneider

I'm trying to figure out how to best create it, so don't love what I have so far. My excel file we are using we don't want to continue to utilize. This is what our Excel file looked like. I was really hoping I could change to a calendar view and see names but it's not working out that way.

I would love to change from Excel to Smartsheet so I could automate some reminders, utilize notes field for shift notes and have the entire year in one sheet but utilize different views for the months. Hope that makes sense! Thanks!