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

  • Melissa Yamada
    Melissa Yamada ✭✭✭✭✭

    Hello @mballe

    You can do it using Date Shuttle. You'll have to:

    1. Create an offload workflow on your main data sheet and make it as an attachment on your secondary sheet.
    2. 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.

    https://help.smartsheet.com/learning-track/data-shuttle

    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

  • mballe
    mballe ✭✭

    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?

  • mballe
    mballe ✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!