Auto populate from one sheet into blank rows on another

Hi All!

I searched for this, but couldn't find an answer. Maybe it doesn't exist!

I'm trying to set up a new dashboard for sales reps. In one sheet I will have them fill out all of their activities. I was TRYING to get them to fill out all information on one sheet to keep things simple for them. Is there a way for me to set it up so that when they fill out customer contact information, that info automatically populates into a new spreadsheet that we have just for contacts?

Maybe this is too much for a spreadsheet.

Thanks!

Find more posts tagged with

Forms

Sales

Sheets

Formulas

Marketing

Cell linking

Comments

Andrée Starå

Hi Katie,

Yes, it is, and there are a few different ways to accomplish it. Depending on your set-up and needs.

1. Use Cell linking to link the information from one sheet to another.

2. Use Cross-sheet Formulas

3. Use a service like Zapier or similar to copy the information from one sheet to another.

Please see the attached link/screenshot for more information.

https://help.smartsheet.com/articles/861579-cell-linking

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

I would lean more towards #3 of Andree's suggestions as x-sheet references and cell linking won't CREATE another row whenever a new row is added to the master sheet.

I personally haven't used Zapier, so I can't speak to it's ease of use/flexibility/capabilities, but judging by what I have seen in other posts about it, it may be the best solution for you.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.