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.…
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?
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??
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…
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…
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…
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…
Hello, Is there a way to export a Gantt chart to PDF and also include an image in the file? Thanks! Andrea
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?
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…
