Can't figure out why one column in report has non-matching column name?
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!
Answers
-
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!
Deena Duran, MA (She/Her)
🌟 Smartsheet Overachiever, Mobilizer, and Early Adopter 🌟
🎓️ Core App, Project Management, and System Administrator Certified 🏅
Senior Business Analyst
University of New Mexico Health Sciences
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives