How to copy a column data of a source sheet to a target sheet.

Krunal

Hi All,

Step1 - I would like to copy the column data in a source sheet to a target sheet.

Step 2- After the data is filled in the target sheet column, I will then run a data mesh config to pull the rest of the column data by matching a data I copied in step 1.

Below is some screenshots of the sheets:

Coulmn114 data is coming from a formula which I have : =IF([Move to MPS]@row = 1, [Project Number]@row + " " + [Manufacture Location]@row, "")

Thanks in advance 😊

Krunal Amin

Krunal

Hi Andree,

Seems like I have got a solution for myself using Data Shuttle option.

I achieved this using Data Shuttle. I used the below steps:

• Create an Offload Workflow to export the data
• When creating the data, you will notice there is an option to offload information based on a filter - such as 'Column114'
• Data Shuttle will create a file in SharePoint/OneDrive/Google Drive/Box
• Use that file, to create an Upload workflow to Smartsheet

You will be able to make a file that will contain only specific fields, and enable you to add additional columns.

Thanks for your help anyways.

Regards

Krunal Amin

Andrée Starå

Hi @Krunal

I hope you're well and safe!

Do you want to copy it over, or would it work with a formula?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Krunal

Hi Andrée Starå,

I would like to copy it over to another sheet so it can be my main Unique Identifier for using Datamesh.

Thanks

Krunal

Krunal

Hi Andree,

Seems like I have got a solution for myself using Data Shuttle option.

I achieved this using Data Shuttle. I used the below steps:

• Create an Offload Workflow to export the data
• When creating the data, you will notice there is an option to offload information based on a filter - such as 'Column114'
• Data Shuttle will create a file in SharePoint/OneDrive/Google Drive/Box
• Use that file, to create an Upload workflow to Smartsheet

You will be able to make a file that will contain only specific fields, and enable you to add additional columns.

Thanks for your help anyways.

Regards

Krunal Amin

Andrée Starå

@Krunal

Excellent! Glad you got it working!

Happy to help!