Workflow Copying - Entire Columns

Hi Michael,

Thanks for your response. I am using "Copy rows to another sheet" workflow.

I require 1 column named "Organization ID' values to be copied from 1 sheet to another sheet. I have attached screenshot of the workflow I created.

However, the workflow is coping other columns to the target sheet

Hi Michael,

Thanks for reaching out.

I need to copy Individual Column and NOT Cells. I want to make sure you are clear on that part.

Actually I need to copy multiple columns, may be around 5 columns in a sheet and that is is having 14 columns. Those 5 columns are in different places, say Column 6, Column 9, Column 10, Column 12 & 13.

To start with I tested with 1 Column, but it started to capture the entire columns. Also, 1st wrote workflow to capture those 5 columns I am looking for and it didn't worked and started again with only 1 column

I need to make multiple formulas to arrive different values based on client Input. Example - Course Assignment Date is a column I will be getting data from system, I will be using this Assignment Date value and will convert to Assignment Month, Assignment Week in a Year and Assignment week in a Month.

Initially I made all these formula in the target sheet itself. However, I am using Data uploader to dynamically replace all of the values in the target sheet and its wiping out all of my formulas.

So, I tried this approach by using a workflow to safely copy the data I required.

Hi Michael,

If I Need to just Copy and Paste. Particular Cell which I require, again I am using REPLACE option to generate data from Data uploader, I may not get the data updated. Already I tried using CELL LINKING even that doesn't work properly.

Copy and Paste will NOT give desired results.

It is not easy to do. Basically I am brining employee training status details with same employee brining multiple line Items. Also the challenge is, using formula's will not refresh the values automatically. As I mentioned target data receiving in the sheet is replaced. I am working to fix that with another support person in community.

Coming back to square 1 - Why does workflow is capturing the entire columns in the sheet. When I am selecting only column in workflow to copy ? Is it a product defect ?. Brining Unique ID and such as EE number and making a formula to capture other columns based on EE number is not working. Due to replacement of actual values. It will get errored out

To avoid this, I simply using CELL LINKING, again cell linking is not getting updated. I need to look for an alternative from Data uploader option avoid REPLACEMENT

Failing in 1st 2 options. I picked WORKFLOW. That also failed me in this case.

Hi Alyssa,

Thanks for the Information. Let me try your suggestion