Setting start date for Calendar

Karen Nankervis

Hi, I've just started using Smartsheet so hoping it will do all the things I need.

My chart calendar starts in September 2014 even though all the things on my chart are from March 2015, how do I fix this, I don't want to have to move the bar along every time

thanks Karen

JamesR

I believe you are are talking ablou the Gantt chart view?  If so in the Gantt Chart Settings (cog symbole top bar left corner of Gantt Chart) there is an option to open to current date ubder Timeline Display..

Travis

JamesR suggestion of setting the Gantt chart to open to todays date will fix this for you but it sounds like you may have a task that was scheduled for September 2014 (possibly by mistake). I would check the dates in your sheet or scroll through your Gantt chart and see if there are any Gantt bars that go back that to September 2014.

Claire Diener

Is there a way to not have the ganyy chat open to today's date, but open to 5 days before today's date? I want to easily see which items have not been completed by the they are assigned, and don't want to have to scroll on the gannt side of the sheet.

Thanks!

BobbyLite

Claire, there isn't a way to open the Gantt chart to five days before todays date... Your best bet will be to open the sheet then scroll slightly to the left in the Gantt

JamesR

Claire,

 

This sound like a job for conditional formatting, involving a calculation based on the comparison of the end date and todays date and the % complete column. The result could be used to conditionaly format any tasks that have not been completed by thier due date or could use a symbol field to Flag them.  You would then not need to sctroll the Gantt chart.

Claire Diener

Thanks, James. Yes, I already have some conditional formatting in use - changing the color of text, and flagging them, I was just hoping for one more visualy representative element with the gantt.

Marcia Hutchinson

JamesR's suggestion worked for me!  Thanks!  I was so tired of scrolling right.  The setting wheel was a little hard to find but it is there if you scroll all the way to the left (start date) of the gantt.