-
Start & Finish dates based on separate predecessors / or formula in duration
I am trying to automate my schedule for a project as much as possible. I have a line for production start that is based on my current ship date but I have 9 shipments after that and would like to have the actual production line have a start day based on the production start line and the finish date be the last ship date.…
-
Use a SS and a FF Dependency on one work item
Hi - i have weekly meetings scheduled for the duration of a ~2 yr project and I'd like to use a SS dependency from the kickoff and a FF dependency from the last work item to set the duration of the weekly meetings, is this possible?
-
Remove Gant view from Dashboard report
Hello, I added a date column to my report to show the actual date in the Dashboard but for whatever reason, the Dashboard wants to display the Gant view only for the date column. Can I turn the Gant view off so it only shows the actual date like it displays in the report??
-
SUMIF Formula returning incorrect number
Hello! Smartsheet newbie here:) I was trying to use a simple SUMIF formula to calculate the total number of days for a specific field. For example: I want to add all the days or duration for all projects that were labeled as "Conversion" together to calculate the total number of days spent on all conversions. However, from…
-
Changing actual start date - Predecessors delete
Hi, I wonder if someone can assist me. I am running schedules for construction projects with predecessors (Finish-Start relationships) set up. If myself/or another employee change the actual start date of a line item then it deletes the predecessors. I know that to avoid that from happening - You must either change the…
-
How do i add more than one duration to a gantt chart?
I have a project that has hundreds of tasks. Each task has a fabrication duration and a delivery/logistics duration. How can i add an extra column and add the extra duration per task to show in the gantt chart in maybe a different shade or different color? The other solution, would be to add a line below each task just for…
-
BUG?! - Inconsistent Date Format (US/UK)
I have a regular gantt sheet with start date / end date, which shows up in UK format on the sheet as per my personal settings. However, when I link to that cell from a metadata sheet that I am using for dashboards the date shows up in US format! I have another date format column which is for baseline start and baseline end…
-
Exporting Gantt View to PDF
Hello, Is there a way to export a Gantt chart to PDF and also include an image in the file? Thanks! Andrea
-
Visually Tracking Changes
Is there a way to visually/graphically see changes to an activity "before and after" on the Gantt or calendar view? I.E. if an activity is running longer than original input is there a way to show the original end point and the added time?
-
Disclaimer
My office creates schedules for our customers which are intended to provide an overall estimate of time involved to ; but not a guarantee. We would like to include a conspicuous disclaimer or splash screen in some way to ensure that the intent is abundantly clear and the schedule is not mis-used. I have placed notes in…