Auto Populate second sheet

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

Find more posts tagged with

Forms

Non-profit

Sheets

IT & Operations

Cell linking

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…