Copy row to another sheet - created date



I was having 2 smartsheet and usually when there is a need the row will be copy to another sheet by using automation.

And at the new sheet I am trying to sort "created date" (the auto Number/system) as descending to let the new copy row to be on top of the smartsheet. But I found out the "created date" column was the date that created at the original smartsheet.

Is there anyway or possible to make copy row to new sheet with new auto created date? So that we can know which request is the new request that has been added in.


Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Jacelyn Lok

    Hope you are fine, try to use system column (modified date ).

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"