Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Setting start date for Calendar

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
Comments
-
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..
-
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.
-
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!
-
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
-
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.
-
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.
-
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.