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.

Comments

  • Paul Newcome
    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?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Paul.Koetke
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!