Tips and Tricks for Copying Row to Another Sheet

We keep master list of everyone who calls our hotline and all of our outgoing calls. Oftentime, other staff import a sheet of calls to be made, for whatever reason, there is overlap in the information but every one uses their own system.

I would love to save time by copying a row from one sheet to another and have the information fit into the master sheets categories (and the other way around). Is there a way to to this.

Example:

Master sheet colums: date, staff, name of caller, phone number, notes, student name, application ID number

Special issue sheet columns: application ID number, student name, parent name, phone number

So when copying a row it inserts the information after the regular columns of the master sheet, and I am not sure that cutting and pasting saves us any time.

Thanks in advance for any suggestions.

Find more posts tagged with

Sheets

Education

Comments

Matt K.

I believe the cut and paste is a literal move. In other words, it's just going to place it in the new sheet like it was in the previous. What if you hyperlinked back to the sheet or cell(s) that you want to copy and paste from?

Travis

Hi Michele - when you copy or move rows from one sheet to another, Smartsheet will add the data to similarly named/type columns. For example if Sheet 1 has columns “A, B, and C” and Sheet 2 has columns “B, C, D”, when you copy a row from Sheet 1 to Sheet 2, data from columns B and C will be added to columns B and C in Sheet 2 and a new column will be added for the data from column A.

In your example your Master sheet columns are: date, staff, name of caller, phone number, notes, student name, application ID number

Your special issue sheet columns are: application ID number, student name, parent name, phone number

When copying a row from the special sheet to your master sheet, application ID number, student name, and phone number will be copied to the corresponding columns while parent name will be added to a new column called “parent name”.

Just make sure the columns name and type are identical between your sheets, or new columns will be created in the destination sheet.

Here’s information on copying rows between sheets: http://help.smartsheet.com/customer/portal/articles/770589-copying-a-row-to-another-sheet

You might also consider using a report to automatically pull in rows from your special sheets to a master report. Here’s information on creating reports: help.smartsheet.com/customer/portal/articles/522214-creating-reports