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.

https://youtu.be/0yWYR5klloE?si=Z88khLjB6pHXGTXm