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?