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 trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
Good afternoon, I am trying to utilize Linked Dropdown Columns for a manual process we have. We have many sheets that use a "Client Name" column with a dropdown list. Whenever a new client comes on or exits, we have to manually update every sheet that has a Client Name column and update the dropdown list. We do not have…
This should be straightforward information but I can't find it anywhere. How do the Automation triggers work for attachments? I assumed: An attachment is Added = New attachment An attachment is Changed = New version of existing attachment. But I just had an 'Added' attachment notification trigger when I uploaded a new…