Combining columns with the same name from two sheets into a report
Eric Hall
✭✭
If I want to generate a report and I have a "responsible person" column in each sheet, is it possible to combine them on the report? They are not in the same place on the sheets, but currently the report has separate columns coming from the two source sheets
Answers
-
I'm not fully following, but if you have 2 sheets (or 2000) that have the exact same column name (exact!)… yes they will come into a single column on the report. That, fundamentally, is the entire point of what a report is meant to be.
-
Thanks! I realized that the columns were not exactly the same and now that is fixed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives