Display Modified Date/Time in 1 Consistent Time Zone
Is there a way to pull the UTC or server-stored Modified Date and NOT show my time zone's display?
My ultimate goal: we need to display the last modified date AND time consistently regardless of the user's time zone.
Best Answers
-
HERE is a link to a thread regarding time based solutions. There is a link in the main post that provides a solution for converting time zones.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
That is wonderful, Paul. Thank you!
That achieves the entire second part of what I needed to do. But I still need to have my base Date/Time stamp the UTC of the system column, so that my calculations work regardless of which time zone someone has in their personal settings. Is there any way to get the full Date and Time stamp in UTC from "Modified" or "Created" fields, let's say if my personal settings are EST.
Answers
-
HERE is a link to a thread regarding time based solutions. There is a link in the main post that provides a solution for converting time zones.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
That is wonderful, Paul. Thank you!
That achieves the entire second part of what I needed to do. But I still need to have my base Date/Time stamp the UTC of the system column, so that my calculations work regardless of which time zone someone has in their personal settings. Is there any way to get the full Date and Time stamp in UTC from "Modified" or "Created" fields, let's say if my personal settings are EST.
-
If you are tracking WHO created/changed the row, you could build a table out (even in a separate sheet) that lists each user, their timezone, and the difference to UTC.
Then in place of a static number in the formula where you add/subtract hours you would reference this table.
The table would need to be manually created and managed, but once built should provide what you need.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!