Moving rows to another sheet - Need to keep original create date
I have created a sheet and a collection of forms that we are using to have employees complete a daily self-screening for COVID symptoms. The sheet is quickly reaching its maximum row count. I'd like to archive the records (rows) for each month in a separate sheet.
The issue I"m having is that I used the system generated "Created (Date)" field to record when the employee submitted the form. When I move the rows to the new sheet, it updates that column to the date/time that the row was moved (meaning...created on the new sheet).
Is there a way for me to use automation to move the rows, but keep the date/time data from the original form submission in my archive sheet?
Answers
-
You can use a text/number helper column that contains...
=[Created (date)]@row + ""
This should pull the original to the new sheet since the Move Row Automation does not pull formulas, only static data.
-
Thanks for responding. My initial approach when I posted this question was to duplicate the sheet and then delete the "archived" rows from the master. That approach is what caused the date to change. When I used automation to move the rows, it kept the Create Date intact.