Welcome!

Clone Column to another sheet

Hello,

I would like to clone one or more columns from one sheet to another, I mean the complete column, no matter how many rows contain data.

The columns in the other sheet should represent the data in the initial column.

How can this be realized?

Thank you.

Find more posts tagged with

Comments

J. Craig Williams

It depends on exactly what you mean and how your data is set up.

Do you have two Sheets with the same information (or that's the goal)?

Do you have unique keys/IDs in your data?

How is new data added to the first Sheet?

Is this a one time task or do you need to sync from first to second Sheet when new data is updated / added / deleted?

Can changes be made to the second sheet?

This is one use case for what you imply is your goal:

http://ronin-global.com/2018/02/22/smartsheet-secure-your-sheets-with-x-sheet-references/

I hope this helps

Craig

SteveSand

Craig,

thank you for your feedback.

The goal is the following:

I wish to clone one or more columns from the first sheet into a second sheet.

Yes, I need exactly the same data from the first sheet sync (updated / added / deleted), so when the data in the first sheet changes I always have the current data in the cloned columns in the second sheet. I would like to process further these data in the second sheet.

Actually my problem is that sumif does not work on the data and I have to make some process steps to get a report and I do not want to do this in the original sheet, as the data is used constantly by different persons.

Thank you

Stephan

Andrée Starå

Hi Stephan,

Depending on your set up it could also work with cell links.

More info: https://help.smartsheet.com/articles/861579-cell-linking

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

J. Craig Williams

Steve,

Andrée is right, cell linking is also a possible part of the solution. Cell linking is better used when the data locations are not very dynamic, that's why I ask about how new data is added and if it needs to be linked.

Based on your follow up response, there are more features to investigate for your solution:

1. more columns, hidden from Editors (who cannot unhide them). This suggestion is primarily triggered by your remark that "sumif does not work on the data".

2. Reports - various user types (as your team defines them) or individuals could have their own reports for data entry. I encourage user to use Reports instead of editing Sheets directly, where feasible.

I hope this helps.

Craig

Sign in to join the conversation!

Quick Links

Trending discussions

Getting the Triggered by at least 5 other workflows but nothing is daisy chained
Hello, I'm seeing this error for the first time as I expand some capability in an existing workflow. Here's how this section with the error works. Scenario: a user puts in a request on the form with a check box indicating they will later upload the required file attachment. Automation sends a request for Approval with…
Re assign task midway thru
I have a task that started in Sept and ends in Feb. I need to assign it to someone else, but do not want to lose the history of the first employee. How do I do this?
Suddenly receiving multiple emails titled "Your Smartsheet Order has been Activated"
Starting a couple of days ago, I started getting 2 or more emails a day about my account being activated. I have a monthly subscription but have never received this type of email from Smartsheet. The email looks legitimate - the sender is "reply_to@Smartsheet .com" - except for maybe the greeting, which is "Dear Customer".…