Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

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.
 

Work with the copy rows action

Automatically copy a row to another sheet when conditions are met.

PLANS

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Permissions

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.
 

To create a new copy row value workflow:

  1. Go to Automation > Create workflow from template...
  2. In the Sheet change section, select Copy a row to another sheet when specified criteria are met > Use Template.
  3. Enter a name for your workflow. 
  4. Configure what triggers the workflow. 
  5. Select your destination sheet
  6. Select Save.

To prevent infinite approval loops, cells which contain cross-sheet formulas or cell links don’t trigger an automation that automatically changes the sheet (Move Row, Copy Row, Lock Row, Unlock Row, Approval Request, Record a Date, Assign People, Change Cell, Clear Cell, Generate document). To work around this, consider using time-based automation or recurrence workflows.


Things to know when copying rows between sheets

  • The copied rows are retained in the source sheet and added to the destination sheet, and
  • The cell history isn’t maintained in the destination sheet.
  • Copied rows are located at the bottom of the destination sheet. You can drag them to a different location.
  • Any attachments or comments on the row are moved automatically to the destination sheet.
  • Formulas in the row are replaced with static values in the destination sheet.
  • If the source sheet contains columns the destination sheet doesn’t have, these columns are automatically created in the destination sheet when a row is moved or copied.

 

When you move copy rows with system or baseline columns
  • If a column exists on the destination sheet but not in the source sheet, the Created Date column notes the date/time when the row was moved or copied.
  • The Created By column shows the user who moved or copied the row. If the row was moved or copied by automation, it displays automation@smartsheet.com.
  • If a column exists on both the destination and the source sheet, the value from the source sheet carries over to the destination sheet. Unlike other column types, the column names don't need to match.

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:

  • Rows can’t be added to the destination sheet because a column has the same name as a system column on the source sheet.
  • Rows can’t be added to the destination sheet because a system column has the same name as a column on the source sheet.

To resolve this, you can either rename one of the columns or change the column type so it matches the source sheet.

Was this article helpful?
YesNo