Can't figure out why one column in report has non-matching column name?

Drew Wilson

We've created a report consolidating 31 separate sheets each with a "Station" column. However, when selecting the columns, Smartsheet creates a second "Station" column that only references a single sheet out of the 31 source sheets. This column includes the help text "Includes 1 non-matching column name(s)". All "Station" columns in the sheets are named the same and have the same Text/number column property.

Is there another reason I may be missing on why it's creating a duplicate column in the report?

I'm attaching some screenshots for additional information.

2 identically named columns in the report:

Column name and type found in 30 of the 31 source sheets:

Column name and type found in the single problem source sheet (seems the same to me):

I greatly appreciate any help with this issue! Thanks!

Deena Duran

Hello Drew,

Try unselecting the station column that says it’s not matching in your filters. Once you unselect it and save, it should fix it once you refresh your page. Typically, once you do that, the extra column is no longer available as an option.

Let us know if that worked!