How to get calendar view to open to today's date

Robyn Lee

I've read through some other discussion questions posted online and watched the calendar view video but can't seem to find a solution for this issue. My whole team uses a sheet to track our projects. We input the data in grid view and switch to calendar view to see what the next few weeks look like. Up until last week when any of us toggled from grid view to calendar view, the calendar view would open to "today's date". Something has shifted and now when we switch between grid and calendar view it is opening to a random date. It is opening to 1996 for one team member, 1994 for another, and It was opening to 2006 for me up until a few moments ago when it switched to 2013. I've done a scan of the 1000+ lines and there aren't any dates prior to 2021 in the sheet. It's quite frustrating to have to scroll through decades of empty calendars to get to the current date every time we shift views. Any tips or insight here? I've included a few screen shots below to help illustrate how odd this is, especially since it just started happening for everyone on the sheet randomly. Any tips or insight would be appreciated. Thank you!

Katy H

@Paul Newcome has a good troubleshooting technique posted here to confirm that all your dates are in fact being read as dates. I had an issue with dates being read as text recently that caused a related issue.

https://community.smartsheet.com/discussion/78021/why-does-calendar-view-show-incorrect-date

Katy H

@Paul Newcome has a good troubleshooting technique posted here to confirm that all your dates are in fact being read as dates. I had an issue with dates being read as text recently that caused a related issue.

https://community.smartsheet.com/discussion/78021/why-does-calendar-view-show-incorrect-date

Robyn Lee

Thanks for the tip @Katy H. Unfortunately I've run that formula and all of the dates entered into the sheets are reading as dates. I'm not sure where to go from here, a coworker logged in today, and the calendar view opened to 1847.... so we're going backward at this point!

Katy H

@Robyn Lee that sounds like a defect to me.

Depending on your company's subscription, there are a couple of ways to contact support about the issue.

• No matter your company's subscription, you can fill out this form: https://help.smartsheet.com/contact/smartsheetapp
• Or if your company has a phone number to call, you can use that. This is only available on certain account levels though. I don't have that type of account so I am rusty on the details, but the number should be available in your account if you have access. I would start with the form though if you aren't sure!

Screenshots will be very helpful and I would also link them to this discussion so they can do some research on the issue you are experiencing before they respond.