Syncing cells across sheets.

I have a process where I have multiple users entering data into their own individual sheets. I want copy from those multiple sheets into a single master sheet. I also want to update the master sheet cells any time a cell is updated from the individual sheets.

I have been able to get this working, but the linking process is manual. Is it possible to do this without manually linking the cells?

Some searching showed a few post saying you could do this automatically using VLOOKUP or INDEX/MATCH functions. If anyone has gotten this to work, could you share examples of the functions?

Here is a high level Diagram showing what I am trying to build.

Find more posts tagged with

Sheets

Automations

Workflows in Smartsheet

Accepted answers

All comments

Andrée Starå

Hi @Michael Shelley

I hope you're well and safe!

Do you have something unique on each sheet that we can use to connect the data to the correct row on the Master Sheet?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Michael Shelley

@Andrée Starå On the master sheet a unique MID is created when the row from the sub sheets are copied over. Though I haven't passed it to the sub sheets so they are unaware of it. I thought maybe I would need unique ID's (SID) for each sheet that would be included in the row when it's copied over thus ensuring the master row has the SID and MID to use but haven't gone that far yet.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.