Reporting - Using Two Sheets, Getting Duplicate Rows

Mike Rini

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?

Best,

Mike

Andrée Starå

Hi @Mike Rini

Unfortunately, it's not possible at the moment to combine different sheets of data on the same rows in a report, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could combine the data in another so-called helper sheet and then report on that sheet.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mike Rini

Really? That's confusing because there's documentation, and actually videos on your YouTube channel, about how to bring two sheets into one report - that's how I knew I had to have the column titles and formats the same if I wanted to use them in the report.

Andrée Starå

@Mike Rini

To clarify, you can report on multiple sheets, but you can't merge them to the same rows. They will always be on separate rows, even if the column names and similar matches.

Make sense?

Clarification 2, I'm not a Smartsheet employee. I'm a Smartsheet Partner/Consultant.

Mike Rini

Got it, thanks. Just seems odd that the join between the two sheets wouldn't put things on the same row

Andrée Starå

@Mike Rini

It's because of the structure of Smartsheet in general, and it might be possible, but then we would need to have something that indicates what should show where.

It would be a great feature to have because it would save space.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Chris E.

We are one month away from 2024, and this is still an issue! UNBELIEVABLE!!!!!