-
I love using Smartsheet, I am still learning how to set up my project management sheet
I wish I knew how to set up alerts specific to certain people. I also, would like to learn more about restricted access to what customers can see vs. clients or vendors (etc). I am still confused about how to use the Gannt chart in our industry.
-
2 days task do not create 2 days calendar events in google cal
I have a task in SS on a Gantt chart sheet, Start date 21/08/2015 and 2d duration. When I export this sheet to a google Cal the corresponding event in a 1 day event with the following Description: NOTE: This event was published from the Smartsheet named "HL Callendar". Changes you make in Google Calendar will not be…
-
Is there a planned development / release date for % of resource to impact scheduling?
I.e. an effort based as opposed to duration based scheduling? At this point, I feel like I am doing all the scheduling work, and Smartsheet is only providing some reporting features. Standard PM methods would be assigning a resource to a project on a percentage basis (common in real world) and let the tool determine…
-
Project light status, Entire Row format & due date
Hi: what would be the formula for the following: project light status | Start Date | Proposed finish date | Finish date | Complete G 1/1/2015 2/10/2015 2/10/2015 complete R 15/1/2015 2/10/2015 3/15/2015 overdue/ At risk in both cases, Start date is pedecessaor to Proposed finish date and Finish date. So when we have a…
-
User Management and Contact List type
Good morning, If I am understanding this correctly, the User Management is what the Contact List type draws from to populate names. Is there a way to create different groups within the User Management area? For instance, I'd like to have two separate lists so that I can have two different Contact List types in my sheet.…
-
Formula's for [Start Date] column when dependencies are enabled
Hi, I am currently trying out Smartsheet in order to decide if we will be able to use this at our company or not. I'm using the construction timeline with gant chart template. I would like to add project management fee payment dates as milestones. Payment #1 linked to start of the project -> OK, no problem Payment #3…
-
Is there a way to hide a completed row (% Completion Column) in a project?
Using a project smart sheet with Gantt functionality, I would like to be able to hide competed tasks in the project sheet. It is used for production scheduling so the once a task is completed it is not needed to be viewed again unless desired. Note... predecessors are used so deletion of the task is not desirable.
-
Initial Setup Assistance: Hierarchy Req- Multiple Clients, Multi Projects, Multi Tasks
Before I get to it and go crazy generating all my works, can you please offer assistance in the best way to set up SS for my needs. Essentially, I want to be looking at one project at a time...my trials have left me with multiple tabs across various projects and clients, it gets confusing. If you are familiar with OneNote,…
-
See summarized duration/ % for header tasks
I have created a master sheet that links all my project gantt charts. Unfortunately I cannot see the summerized totals - is this available as an automatic function? I've been manually typing it in, but I'll have a lot of projects so this would be great if it was automated!
-
Production/Manufacturing/Importing
Hi we do alot of importing of containers and production/manufcaturing jobs is there a smartsheet that we could use to have all container imports in one place? what would the best template be to use? It would be easy to use one sheet for each but we really want to have it all in one place if possible?