How to visualize the same timestamp that I see in the grid(sheet) and in dynamics view?
Answers
-
Dynamic View stores the System Dates and Times as UTC times, which may be different than the timezone that is displaying in your sheet.
Here's more information: Troubleshooting: How Smartsheet handles time zones
System columns always use UTC in the back-end, while the display value matches the time zone of the last person to access the sheet. This means that, although the display value is in the sheet-viewers time zone, formulas and API calls using system column data may return based on the UTC time zone.
Dynamic View uses API calls, which is why the time is different. I hope that helps!
Cheers,
Genevieve
-
Hello Thank you for your answer. my problem is that im tracking the issues in hours so I will continue with these problem :/
Thanks for your support.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!