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

  • cantpickname
    cantpickname ✭✭✭✭
    Answer ✓

    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

  • cantpickname
    cantpickname ✭✭✭✭
    Answer ✓

    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.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!