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

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

Find more posts tagged with

Sheets

Automations

Accepted answers

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

All comments

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

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.