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

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.




Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!