Combining two sheets?

cdale

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!

Mike TV

@cdale

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.

Mike TV

@cdale

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.

cdale

Thanks, @Mike TV !