Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Can't get column data from more than 1 sheet
Comments
-
Hello John,
The usual cause for information to only show from one sheet as you've described, is if the columns in the two different sheets are spelled differently, or if they are different column types.
You can confirm this in the Report builder. You can go to where you selected the column to be included in the report, and hover over that column name. The hover window will give you a list of how many sheets that column is in. If it only shows one sheet, you can then go to the other sheet and adjust the column name to match exactly (including capitalization) and verify that the column type is the same (Right click on the column header > Edit Column Properties).
Once the names of the columns match, it should then pull correctly in the report. If they do match and it still isn't pulling correctly, please contact support@smartsheet.com with the issue and they will be able to troubleshoot further.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives