Copy Row with System Columns

This discussion was created from comments split from:
Copy some cells from multiple sheets into one sheet
.
Answers
-
Hi Andrée,
Thanks for your suggested solution. I am going through the same issue and was looking for a way to pull only specific columns from multiple sheets into ine central sheet. I liked your second option more, however, both of my source sheets already have a different "Auto system columns" in each, and whenever you Auto-copy their rows over to the target central sheet, the workflow breaks down since the auto number column in target doesn't match either auto columns in either source sheets. Any idea how can I work around this issue?
Thanks in advance!
-
I am trying to visualize what you are asking. If you are looking for an automation to do this, that is where you might run into problems.
Otherwise there is a solution around this to pull in specific information from other sheets using INDEX/MATCH formulas.
Solution 1: Have a column labeled "Auto-Number" but it is just a text column. This is where you are going to place your unique identifier (the Auto Number from the other sheets). Then in the other columns you are going to use the INDEX/MATCH formula. So you will have a column that is INDEX/MATCH Sheet 1, then another for Sheet 2, another for Sheet 3, etc. Then use a singular column with the name of what you are pulling in with a JOIN function from the other INDEX/MATCH columns.
Solution 2: Have a column labeled "Auto Number" that is the same text column like above where you will manually place the unique identifier. Then you will have a column that uses and IF statement. Something like
=IF(CONTAINS("Words from Unique Identifier Sheet 1", [Auto Number]@row), INDEX/MATCH Sheet 1, IF(CONTAINS("Words from Unique Identifier Sheet 2", [Auto Number]@row), INDEX/MATCH Sheet 2, etc etc etc
If this is simply WAY too many rows that you need to send, then I would recommend a Data Mesh addition to your Smartsheet package.
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives