Learning Track
This Help Article appears in the Level 2: Intermediate Users learning track. Get the most out of this learning track by starting at the beginning.
This Help Article appears in the Level 2: Intermediate Users learning track. Get the most out of this learning track by starting at the beginning.
The sheet Owner and Admins on both the source and destination sheets can create an automated move or copy rows action. A license is required.
Anyone who can make edits to the sheet (either directly, through a report, or through an update or approval request) can potentially trigger an automated move or copy rows action.
With the Move rows and Copy rows actions, you can automatically move or copy a row to another sheet when conditions are met. Here’s an example:
To create a workflow that automatically moves or copies rows, both you and the owner of the source sheet must have Owner- or Admin-level sharing permissions to the destination sheet.
In your source sheet:
To prevent infinite approval loops, cells which contain cross-sheet formulas or cell links won’t trigger an automation that automatically changes the sheet (Move Row, Copy Row, Lock Row, Unlock Row, or Approval Request). To work around this, consider using time-based automation or recurrence workflows.
Keep the following in mind when moving or copying rows between sheets:
If a system column or a baseline column has a name that matches a column with a different column type (dropdown, text/number, etc.), you may encounter the following errors:
To resolve this, you can either rename one of the columns or change the column type so it matches the source sheet.