Report from 2 sheets shows same column header twice and doesn't combine

Ashley Styers

I have a report of a combination of 2 sheets. Everytihng is the same but they both have one column called "Event Sub-Type" and for whatever reason, the report shows 2 "Event Sub-Type" columns (it doesn't do this with any other duplicate columns, which is extra weird.) Instead, both columns are next to one another and depending on the sheet, one column is empty.

Anyone have a way to combine them? I'm running a calendar off of it, so I need them all in one column.

Thanks!

Ash

Andrée Starå

Hi @Ashley Styers

Ensure that both columns are named the same and that they are the same type of column (single select or multi-select). Both have to be the same.

Was that the issue?

I hope that helps!

Be safe and have a fantastic day!

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!

Andrée Starå

Hi @Ashley Styers

Ensure that both columns are named the same and that they are the same type of column (single select or multi-select). Both have to be the same.

Was that the issue?

I hope that helps!

Be safe and have a fantastic day!

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!

Ashley Styers

OMG that was it!!! THANK YOU! This has been making me insane for a week!!

Andrée Starå

@Ashley Styers

You're more than welcome!

Madyson Morris

Hi Ashley!

I am glad your question was answered. I can totally see where your confusion came from! Questions like this are a great way for us to see usability problems and make the product even better in the future.

Thank you for using Smartsheet and being part of the Community!

-Madyson, Product Manager for Reports

APalani

Hi Andree,

I have 2 sheets, both have same primary column name, have some similar column names with properties and additional independent column names. But I am able to pull the information from one sheet but not the other. Can you please me with this?