Created on date stamp
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!
Answers
-
@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 :)
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives