How do I automatically copy rows within the SmartSheet to a new row

Felicia Wilson

I have a sheet and I want to copy an existing row of data to a new row of data in the same SmartSheet and change the value on one of the columns when its copied. is this possible?

Brian_Richardson

Yes with an intermediary sheet. Because row copy is only outbound to another sheet, you basically copy to another sheet and then trigger an automation on that sheet to copy it back to your first sheet.

If you need to change a value then change it in the intermediary sheet using a Change Cell Value automation, then the new value will copy into your original sheet.