Display Modified Date/Time in 1 Consistent Time Zone

Options

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 ✓
    Options

    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 ✓
    Options

    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 ✭✭✭✭✭✭
    Options

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!