When I switch from grid view to calendar view I get May 5194 instead of the current date. I have a sheet with a "from date" and "to date". When I use the previous and next buttons from the calendar view the dates jump around randomly. Any ideas?
Have you ensured that the date in the sheet are correct? Are they being populated as actual dates instead of text strings that just look like dates?
Thanks for the response Paul, it's appreciated. I've selected the "Restrict to dates only" option on the column properties, so I don't think that's the issue. But the date values are being typed in, so would that override the data type?
Either way, what's happening is, when I switch to Calendar View, the date the calendar is set to is like May 5194.
They should all be dates, but an easy way to check is to insert a temporary helper column (text/number) and apply this column formula:
=IF(NOT(ISDATE([Date Column Name]@row)), "NOT A DATE")
Then apply a quick filter to show only rows that have "NOT A DATE" in them. If nothing is displayed when you apply the filter, then it means every row is in fact a date. You can then remove the filter and the temporary column and the sheet will be back the way it was.
It is odd that it would take you to a date that far in advance. I wonder what is the maximum number of days in the future Smartsheet can calculate. I would be curious to know whether or not that is the date it is taking you to when you switch to calendar view.
You can also check the data within the dates by doing a quick sort. If you don't want to risk accidentally saving a sort you don't want, you can use the temporary helper column method and use the column formula of
=YEAR([Date Column Name]@row)
Then you can see what options you are able to filter on to see if that year number is an option. If it (or any other year number that doesn't belong) appears as a filter option, you can apply the filter, fix the date, then remove the filter and helper column.
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.