Select which columns to copy or move from one sheet to another

This would be a huge benefit for my team. While I know that INDEX and Datashuttle are potential options, I'm looking for something simpler.

Being able to select (or even map) copied columns and automating a copy of those columns using a manual trigger (like a checkbox for "Copy to target sheet"), would save my team quite a bit of time because we don't need (or want) all columns from the source sheet moving to the target sheet.

Based on what I've seen Data Mesh requires some form of unique ID to already exist in both places, correct?

Our use case is new team member information being submitted, then we need to have them transferred to a new sheet manually to track onboarding requirements. Not everyone added to the main sheet needs to be onboarded and we will not already have their employee ID (nor do we want it) in the target sheet to match with the source. At the start, the unique ID could be anything from their name, position code, or employee ID. We may have all of that information, but we many also only have one of them (and need to track down the rest).

Instead, I'd like to be able to click a checkbox when I decide someone needs some sort of onboarding help, then have it shift over common fields like name, manager, team, project, start date, location, etc.

We use Move and Copy Row automation in many of our processes. One 'unfortunate' component of a Copy\Move action is that the ENTIRE ROW-all columns of data- must be handled in one package. Wouldn't it be great, if I could tell the automation specific columns to move forward?

Example: Copy\Move entire row out of sheet one, but only populate specified fields in sheet 2.

This would allow me to set conditions to "Pass Data Along", but not have to send all the data related to Process #1 into Process #2. Our example is a Universal Schedule, that, once a condition is met can pass along core data to several downstream schedules based on project status point being reached.

This would be a very helpful feature. Oftentimes we want a row to be moved or copied to another sheet (and usually have an Automation set up to do this for us when a specific Condition is met), but we do not need all columns from the original sheet to move/copy over. This lends to our secondary sheet having unneeded data that we have to Hide. Being able to select which columns are actually moved/copied, would save time and make our secondary sheet more specific to its purpose.

I love the automation to move over rows automatically, but being able to choose which columns data is moved from would be ideal.

We use a sheet to track our recruitment efforts (with interview dates and other information) but when we hire someone, we don't need all the misc. dates and information to come into our current employee sheet.

It would be great if a user could block a row ID from moving with the row when copied/moved to another sheet. Either by allowing a user to select which columns are included in copy/move row automations, thus allowing a user to exclude an auto number column, and/or adding an optional configuration for auto number columns that overwrites existing row IDs that are copied/moved over from another sheet. There have been a number of times where not having this ability has prevented me from setting up a sheet-to-sheet workflow to accomplish a specific task. The simplest example is when I use an automation that effectively duplicates a row by first copying it to a helper sheet, which has its own automation that immediately moves the row back. This only works if I don't have a need in my sheet for unique row IDs.

Hey, if anybody is still looking at this thread - we're actually building a Chrome extension called Hypesheet with a "Data Sync" feature that aims to solve this exact problem!

I noticed so many comments about needing to selectively copy columns between sheets, especially in automated workflows. We're designing our extension to let you pick specific columns when transferring data, keeping your destination sheets clean and focused.

Just curious - would preserving comments and attachments during these selective transfers be important for your workflows?

We'd love to make sure we're building something that actually solves your pain points. If anyone's interested in testing early versions or providing input on the feature, feel free to reach out!

David Bernal
david@thoughtfire.studio

Founder | ThoughtFire studio
thoughtful technology for humans