Reporting - Using Two Sheets, Getting Duplicate Rows


Hi All -

I've created a report which uses two sheets. The goal of the report is to leverage columns from both sheets as they both have data I want to report on. Sheet 1 actually copies to Sheet 2, so all the formatting and column names are the same, but there are additional columns in Sheet 2 for other reasons.

When I build the report I can tell that Column names / formats are ok because I only see one Column Name where they cross sheets. My problem is, where there are rows in both sheets, I see two rows in my reports, and if I add Sheet name to the report, it verifies that. My question is - why is that happening and how do I stop it?

I only want one row of data, but instead I'm seeing this:

Column 1 Column 2 Column 3

ID - 1234 Client A $1,200

ID - 1234 Client A $1,200

There's nothing different about the rows other than the sheets they come from. Can you tell me what I'm doing wrong?





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!