Linking/adding rows using 2 spreadsheets

Jose da Silva

Hi all,

I am having an issue that might be simple to solve, but I can't seem to find an efficient solution.

I have 2 spreadsheets:

- One with the ID, name, Lot and several other columns with product specification information

- Another just with the same ID's, names and Lots, and a few bits more that don't pair with the first one.

On the first spreadsheet, the QA team fills a form that will issue individual rows for each product.

What I want to happen is, everytime the QA's fill up a form (add a row to the first spreadsheet) I want to see that also reflected on the second spreadsheet, copying only the common items (ID, name and LOT).

I've tried to do "Cell linking" but it only worked for the ones that are already there.

 

Any solutions?

 

Thanks in advance.

Paul Newcome

The only option for doing this without a 3rd party app/tool would be to pull a report. Will that work for you?

Paul.Koetke

Hi Jose, 

Look at Azuqua and Zapier. They can be used to create conditional actions within Smartsheet and other platforms. For example, you can set a trigger sop that when a new row in created in a certain sheet it will then automatically copy specific information and paste it in a new row in another sheet. 

Let me know if this helps, otherwise I'm happy to brainstorm other ideas. 

 

Paul Koetke

Upwork - Smartsheet Consultant