Auto Populate second sheet

Nick Varner

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

Shaine Greenwood

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

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

-Nick

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?

 

Shaine Greenwood

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

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å

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