Copy and move selective columns

TKh

is there a simple way to copy columns from one sheet to another similar to excel without such complicated instructions? Does Smartsheet has a simple way of doing simple tasks?

玛丽∙安

Adding another users request for this feature, we need the ability to copy select columns from one sheet to another.

Unless I'm missing something, the data mesh, vlookup or index/match won't work if you don't have data in the new helper sheet to pull from.

The concept here is that I want to share data from a source sheet into another sheet for people to utilize, I have nothing to match and nothing to mesh.

I guess one option would be to download your source sheet, load it into data shuttle and then you have the ability to manage which columns populate a new sheet. The issue is that there is no automation to run an export of data so exporting the data then saving it to a sheet or sharepoint to shuttle is all manual.

Danielle Wilson

@Mary AnneIf you do haveDataMeshon your account, that's what I'd recommend for that! If you use the "Copy and Add" mode in DataMesh it can essentially do an INDEX/MATCH that pulls in new unique IDs as well, so you don't already need to have the value in the sheet to look up against. It's essentially the Data Shuttle tool for when you want to bring data from one sheet (or report) to another sheet (instead of from a CSV/XLSX file to a sheet).

玛丽∙安

@Danielle WilsonCan you send me more information on how this is done? When I look at DataMesh it wants me to have a lookup value in both sheets to tie the data together.

What I am trying to do is copy 5 columns worth of data from my source and add it to my target where the target starts with nothing in it. When a new row is added to my source, I would like all 5 columns of that row's data added to my target.

I created a new DataMesh and gave this a try, but nothing copied over when the mesh was run. It successfully ran but didn't pick up any records. I'm guessing that's because my target doesn't have a value in the lookups value field.

If you can send over the instructions on how you do a copy from a source and add it to the target as new rows / columns with no target sheet value in the lookup value field that would be great.

Danielle Wilson

Hi@Mary Anne——你仍然需要有一个查找列希利cted in both the source and target but you don't need to have those 'keys' already populated into the target sheet, if that makes sense. For example, in this config, I have Lookup Columns selected (which I need to have) and the columns that I want to map over. BUT, when I run this, even if my "Time Submission" target sheet is totally blank before I run the DataMesh config, upon running the config, the target sheet will populate with all of the values for those three columns (if I didn't want all of the Email Addresses to come over, I could first make a report to filter out the values I didn't care about bringing over). It works in this way specifically because I have "Copy and Add Data" selected as the Data Mapping Format.

If you do have DataMesh access, I'd recommend reaching out to your CSM for some help getting started or booking aPro Desksession if you have Pro Support.

玛丽∙安

@Danielle WilsonTHANK YOU so much for this info, totally worked as I did forget to change the mapping format to copy and ADD data. This is fantastic!! Exactly what I need, now I can delete my data shuttle!! :-)

Melvin Collins

Copy only cells in a row with value to another sheet. Smartsheet currently only can copy the entire row which can give you a lot of empty space from a form you may not want. I.E., If there are 25 columns or form questions and I only want to copy cells from that row that have data in them and the cells with data may change on each form.

When an end user fills out a form and ask for a copy smartsheet sends an email with only the data the end user entered. I need this exact result

LAM

I need to be able to copy a row, cell or group of cells and paste them into another sheet. I often reference prior project schedules for lines needed on a new schedule. Being able to copy the item (rather than clicking into the cell and copying text) would make this much more efficient. Thanks or your consideration!