-
Cost Data Not Exporting to Microsoft Project
I am a hardware engineer. My project engineer starts by handing me a Microsoft Project file so I can fill in the details of how long each task is going to take and how much cost will the labor and materials will be. I prefer importing the project file into Smartsheet so I can easily arrange the trench work and subsequently…
-
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!
