Copy rows to another sheet

Avoid manually duplicating your work by copying rows from one sheet to another.

Who can use this?

Plans:

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Permissions:

  • Owner
  • Admin
  • Editor
     

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

 

You can copy rows automatically with an automated copy row workflow. 

Copy rows from one sheet to another 

Keep in mind that you can only copy 500 rows at a time. 

  1. Press and hold the Shift key (to select a range of rows) or Ctrl key (to select disparate rows), and select the row numbers on the left side of the sheet grid.

Child rows are included when you select parent rows. After copying the rows, remove the child rows from your destination sheet if you don't need them. Learn more about parent and child rows. 

  1. Right-click the highlighted selection.
  2. In the row options menu More kebab menu. , choose Copy to Another Sheet.
  3. In the Copy to Another Sheet dialog, select your destination sheet. 
  4. Select the checkboxes for Attachments or Comments to include those in the copied row if needed. 
  5. Select OK.
  6. Open your destination sheet and go to File > Refresh to see the data. 

Cell data that you copy from a row (or multiple rows) from the source sheet appears on a new row (or rows) at the bottom of the destination sheet. This process doesn't affect the source sheet.

This feature isn't available for columns. However, you can create a new column in the destination sheet and then copy and paste it to populate it with the cells from the source sheet. Or, you can use column links or linked dropdown columns to have consistent column data across sheets. 

copy a row to another sheet

Troubleshooting

Here are some things to be aware of when you use this method to copy rows to a new sheet:

  • You can't preserve predecessors and formulas, but you can copy and paste them between the two sheets.
  • Your source and destination columns should have the same column names. If the source and destination sheets have different column names or types, data from the row you copied appears in new columns to the right of the existing columns in the destination sheet. If this occurs, scroll to the right to find the data, copy it, and then paste it into the desired columns.

Error message: These Rows Cannot Be Moved.

If your source sheet includes system columns, and the destination sheet contains columns of the same name that aren't system columns (or vice versa), you may receive the following error message:
These rows cannot be moved because this sheet contains a System column with the same name. 

To resolve this, you can rename the column or change its type to match the source sheet. 

Learn more about system columns.