Gantt Chart + Start/Finish Columns

Emily Khalil

I have a need to combine the detail of the start/finish date from the grid view with the visualization of the Gantt chart view. Is this possible? 

Tim Meeks

Emily,

 

The Start/finish date should stay when you are in the Gantt view. There should be a slider bar that splits the screen for you to show both.

 

read here for details:

http://help.smartsheet.com/customer/portal/articles/765675

 

Do you mean to just view on the screen or print?

 

Tim

Emily Khalil

Hi Tim,

 

I'm more focused on print, or converting to PDF to share with a client. I can definitely see it on screen well. 

 

Thanks,

Emily 

Travis

Emily, any column can be used as the display label for your Gantt chart. Add a new Text/Number column to your sheet with a formula that concatenates the Start and End dates. Then use that new column as the display label (set through Project Settings). 

 

Here's an example:

 

=[Start Date]1 + " - " + [End Date]1

 

Would result in:

 

03/01/16 - 03/14/16

 

 

Emily Khalil

Not sure that will do it. I've taken a screenshot of the view that I am hoping to achieve. 

Travis

Emily, are you saying you want your PDF to look just like the provided screenshot?

 

While in the Export to PDF settings menu, select the columns you want to include (Task Name, Duration, Start, and Finish), select Portrait for orientation, and Fit to Width for Scaling. 

 

This will print the file just as you have it in the screenshot. Here's an example of the PDF I exported with the same settings:

 

Emily Khalil

Yes! Brilliant! Thank you so much!