Linking/adding rows using 2 spreadsheets

Jose da Silva
Jose da Silva ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!