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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!