Combining two sheets?

Options

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

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @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.

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!