Move Row and System columns

js@mod ✭✭✭
edited 11/10/20 in Smartsheet Basics

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