Single Cell Copy

I have two Sheets. One is my main data sheet, the other is a secondary sheet. The main sheet has a form that creates new rows. The secondary sheet needs one of those cells (containing a unique identifier) to pull in the rest of the data. The question is: how do I automatically create a new blank row in the secondary sheet each time a row is added to the main sheet, and then shuttle over only that one cell for it to pull the relevant information from other sheets?
Answers
-
Hello @mballe
You can do it using Date Shuttle. You'll have to:
- Create an offload workflow on your main data sheet and make it as an attachment on your secondary sheet.
- Create an upload workflow on your secondary sheet that whenever there is a new version of the attachment it'll update your secondary sheet. Only map columns that are necessary.
Know that Data Shuttle is a premium add-on.
If you're not leaning on getting a Data Shuttle, then maybe an API call or a third-party application can help you with that.
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined -
Unfortunately, I use a corporate account that I have no control over and we do not have the Data Shuttle option. I do have a Zapier account that I use for certain things. Would that solve that issue?
-
For anyone looking to do this, I couldn't find a way to complete the task in Smartsheet. Instead, I created a form for the sheet I needed information to populate a single cell and new row in and then created a Make connection with a webhook to shuttle that data into the form when it's triggered.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!