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.