Pull data from one sheet to another when a box is checked.

Kyle Keever

Hi SS Community,

I'm trying to figure out the best way for data from specific columns in a sheet to get copied to cells in an control center intake sheet.

Thanks,

Kyle

Kyle Keever

Thanks for the help Julio. I ended up creating another unique column in both sheets and using for an index formula.

Julio S.

Hi @Kyle Keever,

You may easily copy entire rows either manually or by means of an automated workflow as long as you have the right permissions in both the source and target sheets. Bear in mind that rows with predecessors won't copy and, if you have System columns, they will need to be named equally in the source and target sheets (no other type of Column can have the same name as a System Column from the source).

If you are looking to just selectively map certain column values from the source into the intake target, the best way to accomplish this would be via a DataMesh workflow that maps the desired columns based on a specific value from the source provided that both sheets contain columns with a unique value identifier for each row.

I hope that these ideas can be of help, but if they aren't, please share some screenshots of your current environment (ensuring that any sensitive information has been hidden).

Cheers!

Julio

Kyle Keever

Thanks for the help Julio. I ended up creating another unique column in both sheets and using for an index formula.

Kyle Keever

@Julio S. Thanks for the additional info. I'd be interested in learning more about the data mesh method. Is that something you could elaborate on or provide an example?

Thanks

KK

Julio S.

Hi @Kyle Keever,

Would you be able to share some captures of your current environment for context? This would allow me to elaborate more on a possible solution with DataMesh.

Cheers!

Julio