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.


Answers

  • Andrée Starå
    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Michael Shelley
    edited 07/04/22

    @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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!