Created on date stamp

Zsoltolah

Hello,

Can someone confirm this? When you use the automatic Created on date field, it "stamps" the row at the date and time of the creation. Perfect. While the Updated on keeps changing, this Created on always stays the same. At least, that's what I thought.

Looks like dates in the past (like months ago) changed with the time change. It seems like Smartsheet adjusted the time with that hour change retrospectively on past data. So, for example, if someone logged out at 5pm (let's say this is important for some reason), suddenly the same field turns into 4pm. Then, I assume when we change the clock again, they would go back to 5pm?

Or, am I just imagining this? If not, the only way to work around this is copying the date into another sheet as is, then back to the sheet as a date but not the built-in date?

Thanks!

Darren Mullen

@Zsoltolah The Created datetime willchange based on the settings of the viewer.. I made a video explaining more about this a few years ago. Ha You get to see one of the originals with poor audio quality.

By the way, the solution I present here isn't necessarily perfect and may not address your specific issue. However, it at least gives some background :)

https://www.youtube.com/watch?v=S-GsCr9wA5g

Zsoltolah

https://community.smartsheet.com/discussion/comment/462255#Comment_462255

Thanks, Darren. Well, it's insane. In my case the hours changed. Same viewer (me) but the original hour changed. I knew this because I used a formula and automation so it became text in another sheet, no longer attached to the date. Today, I opened and it changed again. Now with two hours off.