Move Row and System columns

js@mod

Hello community! I set up a 'Move Row' automation with the intention to archive a large sheet at regular intervals. There are several System columns on the source sheet (auto number, create date etc). When a set of rows is first moved to the archive sheet, the archive sheet reflects the same create/numbering data displaying on the source sheet. And, the column data type on the Archive sheet is set to System. Subsequent automation actually fails because I guess bottom line - you can't have system columns in your source sheet and use Move Row more than once. Does that sound right? Or what am I doing wrong? I guess I will need multiple archives if this is expected behavior. Many thanks in advance. /Julia

js@mod

I did find a couple of related posts which helped a bit!

https://community.smartsheet.com/discussion/69507/moving-rows-to-another-sheet-need-to-keep-original-create-date

https://community.smartsheet.com/discussion/67220/move-rows-auto-field-error

I am unable to get the Move Row to work if there is a column on the target sheet with the same name even if it is a text data type (another person seemed to be able to do this successfully). I will just plan on an archiving strategy that uses a new sheet each time a set of rows in archived.