Combining two sheets?
Hi there,
I am new to Smartsheet and hoping to get some help combining two sheets. We have two sheets run by two different teams. The teams would like to keep their sheets separate, but pull some information from one into the other. The sheets do have different columns. Is there an easy way to do this?
Thanks!
Best Answer
-
A report would be the easiest way but you'd want to change the column names/types to be similar between the two sheets.
Otherwise, as an alternative you can build a 3rd sheet which uses INDEX/MATCH formulas to bring in the information from the other 2 sheets. It would be much more time-consuming though then using a report and getting your columns to be similar.
Answers
-
A report would be the easiest way but you'd want to change the column names/types to be similar between the two sheets.
Otherwise, as an alternative you can build a 3rd sheet which uses INDEX/MATCH formulas to bring in the information from the other 2 sheets. It would be much more time-consuming though then using a report and getting your columns to be similar.
-
Thanks, @Mike TV !
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!