Reporting: Linking two sheets on a common column

Christian Jensen

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.

J. Craig Williams

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