Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Does anyone use Smartsheets for employee scheduling? I have about 25 people across four sites that I schedule. There are changes everyday. I also need to save a history of the schedules.
I currently use excel and google docs.
Thank you.
Robert
Hi Robert,
You might try importing your current excel doc in as a new sheet in Smartsheet. More info on this is available in our help center: https://help.smartsheet.com/articles/504553-importing-files-to-create-new-sheets
From there, you can attach any google docs you need to rows in the sheet. (Details on attaching files from Google drive here: https://help.smartsheet.com/articles/518404-deleting-editing-versioning-attachments )
Smartsheet has a resource management feature so you can schedule people across your sites without overallocating them. Details on Resource Management are available here: https://help.smartsheet.com/articles/1346969-resource-management-allocation-team-enterprise-only-
You're also always welcome to reach out to our solutions team to see if you can take advantage of our solutions for your business: https://www.smartsheet.com/solutions
Thank you Shaine,
That information is helpful.
Did you ever get this to work for you? I am looking to do something in this same concept
I’m building a PM Team Workload Dashboard from our project tracker and want to account for the effort each project requires, beyond simply counting active projects. How have you set up workload weighting in Smartsheet? Do you base it on project phase, complexity, estimated hours, or a combination? I’d appreciate examples…
This is probably really simple but I'm not sure how to get started. There's always a lot of crossover between the two & in the past I've re-typed stuff into an Excel spreadsheet. I'm sure there's a way to feed stuff from the project plan sheet to a RAID log sheet but I'm not sure how to go about it. My first thought was to…