Copying data from one sheet to another

Enoch Mak

Hello,

I have a High Level Project sheet i need to copy data from Project 1 sheet and Project 2 sheet. We don't require all the details from the Project 1 and 2 sheet only a few select columns like the project name, date started and ended, and the description.

Here what i need to set up: Something that'll automatedly transfer just the project name, date started and ended, and the description without pulling in the rest of the data.

Is there anyway i could set up automation to copy those rows over from Project 1 and 2 without having to set up formulas in the High Level Project Sheet? I'm hoping to not set up formulas since the High Level Project sheets main columns need to be free text to allow anyone to change things freely.

Darren Mullen

@Enoch Mak

You can't do it with core smartsheet automations, but if you have access to Smartsheet Datamesh or Bridge you could use those.

Alternatively you could use a third party solution like SmartLink.

Darren Mullen

@Enoch Mak

You can't do it with core smartsheet automations, but if you have access to Smartsheet Datamesh or Bridge you could use those.

Alternatively you could use a third party solution like SmartLink.

Enoch Mak

@Darren Mullen thank you i was able to use datamesh to get this to work. I appreciate the info!

Darren Mullen

@Enoch Mak Great, thank you for the followup! Always good to use the tools you have available!