Best way to automatically copy and update rows from multiple sheets to master sheet
Hi all,
I have 10 sheets owned by different people who enter rows of information. Each row on each sheet has a unique code.
I'm trying to do the below actions:
- Copy the rows from the 10 sheets automatically to a master sheet.
- Order them by the unique row code
- Enable each owner to update any cell in any row of their own sheet, which will then automatically update the corresponding row in the master sheet (I don't want a second "same" row to be copied to the master sheet). Every cell in the row can be changed except the unique row code (as a reference point).
Can anyone help me establish the right workflow and formula to enable the above 3 actions?
Thanks,
Ahmet
Best Answer
-
Hi Andree,
For now I'm just extracting from a report.
Works for what I need for the time being.
Thanks for coming back to me.
Best regards,
Ahmet
Answers
-
Have you looked into pulling a report that references all 10 of those sheets?
-
Hi Paul,
I forgot to add - I have another workspace with sheets that need to take the unique row code as a reference and I don't think you can copy a cell from a report into a sheet - is that possible?
Thanks...
-
I hope you're well and safe!
To add to Paul's excellent advice/answer.
- What is the Unique row code? Is it a running series?
- Do you have access to the Premium App, Data Shuttle?
I hope that helps!
Be safe and have a fantastic week!
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 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andrée Starå,
The unique row code relates to a specific customer, so it will not change and I want to use it across multiple workspaces. The code is automatically generated when the customer information is created in the row. It's like a database but we don't create the code manually. It is a running series but each row code is different on each of the 10 sheets. I'm afraid I don't have the Data Shuttle app.
Sorry if it sounds a little complicated and thanks for the help.
Best,
Ahmet
-
I hope you're well and safe!
How did it go? Did you manage to get something set up?
I hope that helps!
Have a fantastic weekend & Happy New Year!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
For now I'm just extracting from a report.
Works for what I need for the time being.
Thanks for coming back to me.
Best regards,
Ahmet
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
If you use unique identifiers on all the individual forms and the master form you can do a vlook up to the master form.
-
Appreciate that Seda - I'll check it out to see if it helps to find a better solution than the one I have right now.
Thanks...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!