Created time is displaying as Pacific Time in Dashboard
I have created a dashboard and added a report to the dashboard. In the published dashboard, the "Created" time is displaying as 3 hours earlier than what the report and Smartsheet is showing. How can I get the published dashboard report to display the correct timezone as is seen in the actual report and Smartsheet?
Comments
-
AverageUser ✭✭It may be related to the timezone that you have set in your "Personal Settings".
I switched mine, created a dashboard, published it, then switched mine back... and it appears that it held on to my old timezone setting.
When you publish the dashboard, are you selecting the option to indicate the viewer has to be logged in to a Smartsheet account? Or anyone with the link?
-
JEarley02 ✭✭✭
The timezone in my "personal settings" is set to EST, which is correct. The actual Smartsheet shows the correct time (EST) and the Smartsheet report shows the correct time (EST), however the published dashboard (web "link") shows the time as PST (3 hours earlier.) Interestingly enough, when I'm in the dashboard in Smartsheets (not the published link), it is showing the correct time (EST) but the published link shows the PST.
The end user does not have to be logged into Smartsheet to see the published dashboard. I leave the setting to "anyone with the link."
-
AverageUser ✭✭
This one seems like a stretch, but...
When you are viewing the dashboard, are you logged in to your Smartsheet account? Or are you logging out of your account (or using a different pc) before viewing the dashboard?
-
JEarley02 ✭✭✭
My end users reported this issue to me. They do not have Smartsheet accounts and only have the link that I sent to them.
I've confirmed the issue by accessing the dashboard via the link, and also when I'm logged into the dashboard and select "preview" in the publish option window.
-
Sheryl P ✭✭✭✭我有一个问题h Created time. I have a formula that sets Date Reported to[email protected]My personal settings is GMT-7 Arizona.
If I create something after 5pm MT - the created is the following date. This impacts my ability to pull out specific records by Date Reported.
Interestingly this morning - the same records seems to have adjusted - must be a process that runs overnight to make corrections ???
Please describe expected behaviors.
-
Has there been any progress or resolution to this? I am experiencing the same, but, I have shared the dashboard with a few people. Only ONE person is having this issue. We checked the PC timezone, that's not the problem. but the "created date" timestamp is 3 hours behind.
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/comment/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/comment/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/G1SDKXPQ7I1D\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/GCQ7U05Q4GNO\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/79GD9D2EWXCW\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
