Auto Populate second sheet

Nick Varner
Nick Varner ✭✭✭
edited 12/09/19 in Smartsheet Basics

Hi,

I have a main sheet with a form. As you know, every time a user submits a form, a new row appears. I was wondering if there is any way to have a separate sheet that connects to the main sheet so when a new entry is added through the form on the main sheet, a column is updated on the second sheet reflecting the new entry. It does not need to reflect the whole row (which would be fine if it did), but only a value in a column.

I hope this made sense!

Thank you,

Nick

Comments

  • Hi Nick,

    You may be able to make the updating quick on your "destination sheet" with a VLOOKUP function. 

    You might be able to create a VLOOKUP over the range of an entire column in your source sheet that will return the value that you need in your destination sheet. More info on VLOOKUP is available in the help center: https://help.smartsheet.com/function/vlookup

    Otherwise, you might be able to create a function that uses both INDEX and MATCH to find the value that you need. More info on this in the following articles:

    INDEX: https://help.smartsheet.com/function/index

    MATCH: https://help.smartsheet.com/function/match

    An example of this type of formula is as follows:

    =INDEX({range1}, MATCH("Value A", {range 2}))

    These functions rely on the ability to reference data from other sheets. I'd recommend looking at our help article on this so that you're familiar with the syntax: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

  • Nick Varner
    Nick Varner ✭✭✭

    Thank you! I will try these formulas out and see what I can come up with.

    -Nick

  • Hawk
    Hawk ✭✭✭

    Hi Shaine,

    Thanks for your solutions on updating destination sheet with VLOOKUP function. But seems it can not automatically update the destination sheet.

    ex. I have 2 sheets, called them as Master sheet and Slave sheet, and both of them have a primary column "Project Name".

    If a new project name added into column "Project Name" in Master sheet manually, is it possible to update the new entry to column "Project Name" in Slave sheet AUTOMATICALLY?

     

  • Hi Hawk—

    It sounds like you're talking about an automatic row creation feature such that when a row is added to your source sheet, a new row is also automatically added to your destination sheet.

    This functionality isn't currently available in Smartsheet—when you have a moment, please submit a Product Enhancement Request for this using the form under Quick links on the right of the community site.

  • Hawk
    Hawk ✭✭✭

    Hi Shaine,

    Yes, I am talking about an automatic row creation feature as your description. And I had submitted this request already.

    By the way, any way to know the request accepted by Product Enhancement team or not? I think smartsheet team should let request owner know these info...

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi,

    It's possible to set it up as Shaine mentioned earlier in the post, with cross-sheet formulas. You could use auto-numbering on both sheets and then it could auto-populate.

    Zapier is also an excellent option for this scenario. It can be set up to copy/move rows automatically. Is that an option for you?

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.