Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Dates don't match?

    ✭✭✭✭✭✭
    in Formulas and Functions

    I have a system date and a column that is pulling just the date out of it with a date formula. for items that are created later in the night it is showing the next day before 12pm local time.

    is this because of the UTC issue?


    image.png


    · Share on FacebookShare on Twitter

    Answers

    • Community Champion
      edited 02/06/21

      Hey @RossL

      Yes, it is because of the difference in your timezone and UTC-0. A work around is to use the new automation Record a Date and trigger off of the the Created field changing to any value. The date that is captured by Record Date is in your local timezone. The time of the Created timestamp is already in your local time, if you needed to extract that.

      Kelly

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions