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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!