Move Row and System columns
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
Answers
-
I did find a couple of related posts which helped a bit!
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives