Report not combining columns
I am trying to build a report from 3 different sheets. We have checked and double checked to make sure the column names are identical. But each time I try to build to report, the columns don't line up. We have two different columns named "Team" and two named "Quarter" and so on. Two of the sheets seem to match up in the report, but the other sheet does not. Any idea why?
Answers
-
Hi @jamesmlee2
In addition to the column names being the same, have you checked to make sure the column types are the same, too?
The columns will need to match in terms of their column properties.
For example, if one column "Team" is set as a single-select dropdown but in another sheet this "Team" column is multi-select, these will be seen as two different columns in a Report.
Also check to see if all your columns have the same restrictions applied (ex. "Restrict to dropdown values only" box checked or not).
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives