-
Gannt chart help please
Hi, i'm using the excel template which smartsheet provide here: https://www.smartsheet.com/top-excel-project-plan-templates in the file ive downloaded the gannt chart looks lovely, however when i add in my project plan which has loads more tasks than the example, and over a greater time period the gannt chart severs no…
-
Can I copy gantt lines from one sheet to another and retain structure?
I have not been successful in copying a project plan (gantt) rows from one sheet to another and retain all hierarchies, durations, progress, dependencies, etc. to make a seamless copy/paste without having to rebuild.
-
Formula to calculate day from a series of dates and times
Hi All, This might be a long shot but is there a formula to search and find a multiple entries of a job number then look for the date column and calculate the series of dates for start and finish time and also include the in and out times to create a Gantt chart? This is all data that will be entered into a separate…
-
Include Gantt Chart in Dashboard PDF
Is there a way to include a gantt chart when printing a dashboard to pdf? I currently use the web widget to add the gantt chart to our dashboards, but when I try to print to PDF, the gantt chart is blank.
-
Working Days
Greetings, I have the start day and the duration. Is it possible to calculate the end date using these two entitites such that only working days are included (only monday through friday and not the weekends)? Thank you
-
Can you vary working days as part of duration?
I have some tasks that can only occur M-F in a schedule, and I have some other tasks that occur throughout a weekend. I don't know how to give the days different designations. I know there is a way on MS Project, but I have not figured it out for Smartsheet.
-
Converting text to Date to populate Gant & Calendar App.
I have an Allocation sheet where I need the user to choose the month in the "Month" column and the 'Start' populates with the first date of the month and the "End" populates with the last date of the month so I can have a start and finish date to show the resource and Allocation on a Gant and Calendar app. I have tried to…
-
How to put in exact dates when tasks have predecessors linked
I have all my tasks linked to predecessors so that dates adjust correctly, but I am now unable to change the date to something farther down the line unless I unlink everything. Does anyone have an idea of how to fix that? Thanks
-
Problem with alignment on dashboard
Hi I need help. I uploaded report to dashboard and the bars are off as you can see on the picture. What I'm doing wrong? On both: worksheet and report of the same I don't see this problem. All is aligned. Only when I upload all looks messed up. Please let me know how to fix it. Thanks
-
When creating a Gantt View Schedule, has anyone figured out how to have a header and footer?
I am creating construction schedules using the Gantt view. I need the project information (Project Name, Address, Number of Floors/Phases) to show at the top of the page when I print my schedule. I have figured out in the print screen I can type in that information and it will show on my printed schedule. However, when I…
