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
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
