Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Reporting: Linking two sheets on a common column

In reporting I have picked two sheets. They have a common primary column name. The columns do consolidate (i.e. there is only one column with this name). But...I have two rows for each, i.e. row 1 is from sheet 1 and row 2 is from sheet two (of course, row 3 is from sheet 1 and row 4 if from sheet 2). Is there anyway to consolidate rows? Otherwise the report has two of every thing printed in the common primary column.

Tags:

Comments

  • J. Craig Williams
    J. Craig Williams Top Contributor

    There isn't a way to combine rows using Smartsheet in this fashion.

     

    There are third party tools (AppSheet springs to mind) that can handle this.

     

    Craig

This discussion has been closed.