Linking/adding rows using 2 spreadsheets
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
-
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!
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!