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

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Can we run the request for update to include all the rows that applied to one condition?
We want to know if it is possible to send request for update in one email, but with multiple rows at the same time. For example, staff A has 4 open referrals, I want to send one request for update automatically to them where they will receive only one email without having to overload them daily with all the open referrals…