Report Builder Gantt Chart is off

Brad Plant

I've been playing around with report builder, to create a summary page of all my sheets. I have a check box I use to filter the lines I want on the report, which are typically the first/top line, which is the entire project. The Gantt view in each sheet is correct, but in the report, every line has the gannt shifted by one quarter (starting and ending 3 months late). 

 

Has anyone encoutered this? I can't find anything that I've done to cause this, and from the support forums the reports are supposed to match the sheet's info, and not do any additional formating. The dates show up correctly in the report, but the gantt line is off by 3 months.

Shaine Greenwood

Hi Brad,

 

This is likely a result of your Gantt timeline being different in your report versus your sheet. 

 

You can change the Gantt timeline in your report by clicking on the gear icon right below the timeline, then selecting Timeline Display. You'll want to make sure that everything here (start of the week, fiscal year, etc.) matches with the Timeline Display of your sheet—you can get to the setting the same way on your sheet.

 

Details on this are available in our Help Center: https://help.smartsheet.com/articles/765755-modifying-project-settings#timelinedisplay

Brad Plant

Thank you Shaine! My fiscal year start was off by a quarter, and the display view was in quarters, which I now understand are fiscal quarters, not calendar.