Copy Specific Columns From One Sheet to Another, Linked

Erik Hartman

Would be great, as an automation, to copy cell data from one column to another column.

Use case:

The workflow triggers an automation based on a change in a cell dropdown value. Once this triggers occurs the workflow processes, and upon completion, there is the ability to copy cell level data in one cell to another cell. Would be great if this is not limited to the same sheet but have the ability to copy cell level data across multiple sheets.

NikkiOno

I would love to be able to only move certain row information to a desired sheet based on certain criteria rather than moving the entire row.

pgregory3

Although automations give the ability to copy rows to another sheet, it lacks the ability to update rows (in the 2nd sheet) when data within the original sheet changes. It would be helpful to have a bi-directional connection that when the master row changes information the copied row changes as well in the connected sheet.

Danielle Wilson

@pgregory3Definitely something I'd recommend looking intoDataMeshfor!

Katrina_27

Hi@Andrée Starå

Sorry just reading through this discussion. Can you help to explain once I create the so called helper sheet then what would is next steps?

Emily T.

它would be helpful for me if in the automations there was a Copy Rows and Link, that would link to the original project plan so that it would update automatically. The issue I'm having is that I'm creating a milestone dashboard with gantt view, but need to be able to change the colors of the gantt chart, which can only be done in the grid sheet. Smartsheets does not allow for changing the gantt colors of lines that are considered headers, subheaders, etc. Only task lines. So now I'm copying rows to another sheet, linking them to the main project plan so they'll automatically update, changing the gantt colors, so I can then create a report showing the actual information I need in order to put in my dashboard. There's got to be an easier way.