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.

    Wrong date pasted when copying "Created date" to "Date" field in Report

    ✭✭✭✭
    in Formulas and Functions

    Scenario:

    A sheet used to track customer request fulfillment has both a manually entered "Date" field and an automated "Created date" field. The idea being if needed, you could enter records after the fact and still track the correct date for reporting.

    The data needs cleaning. I created a report for staff to easily see rows where "Date" is blank so they could copy "Created date" into that cell.

    Problem:

    From the report, I copied/pasted from "Created date" to "Date" and every time it pasted the wrong date. Sometimes it was a few days off, sometimes a few weeks.

    From the source sheet, the pasted "Date" value matches "Created date".

    How can I resolve this?

    Tags:
    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Answers

    • ✭✭

      I was able to replicate this bug as well. When I paste, it is 1 day ahead.

      There are 2 solutions I found:

      💎1 solution is to paste everything into Excel, then copy the cells from Excel and paste back into Smartsheets. This is probably the best solution.
      💎1 other solution is to make sure when pasting, that date column pastes into a text only column in Smartsheets. Then copy everything again and paste again but into the date column.

      · Share on FacebookShare on Twitter
    • ✭✭✭✭

      Thanks for confirming and for offering solutions! I'd initially thought it was a time zone issue like UTC vs PDT, but the variance isn't consistent. For the time being, I'll have our staff copy into Excel then back into Smartsheet (the source sheet historically runs close to Smartsheet's cell limit).

      I suppose I'll need to submit a ticket with Smartsheet for this - unless there's a way to tag Smartsheet support here.

      · Share on FacebookShare on Twitter
    • ✭✭✭✭
      edited 02/17/25

      Delete

      · Share on FacebookShare on Twitter
    • ✭✭✭✭

      Thanks again for the suggestions. It looks like something else may be going on. When I paste the Created Date into Excel, the values don't match what is visible in Smartsheet. Time to pull in support as this is what I see reported for created date/time:

      image.png
      · 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