report not showing all columns from a sheet
![LBou](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I am trying to select a column to be displayed in my report that is on my source sheet but it isn't an option. The column I would like to display is circled in red below.
When I search for it on my report it does not come up as an option:
Anyone know why I can't display the column in my report?
Answers
-
Is it your Primary Column?
-
It is not my primary column in the report
-
It looks like you are filtering more than one sheet into the report, does Group Request ID exist in both sheets?
-
Yes, Group Request ID exists in both sheets
-
I realize that Paul already asked this, but is there any chance it is the primary column in one of the sheets? That is typically the cause of not seeing the column reflected in the dropdown options.
-
I might have misunderstood his question, it isn't the primary column in my report but yes, it is my primary column in Sheet A. I can see the group ID column from Sheet A because it was automatically imported as my primary column in the report. I cannot see the group ID column from Sheet B where it is not the primary column.
-
Got it, when a primary column in one sheet has the same name as another (non-primary) column in a different sheet you will be unable to view the column in a report that combines those two sheets together. You will need to create a new non-primary column in the sheet where you named the primary column that, and name it "Group Request ID" for it to show up in the report.
-
That worked, thank you!
-
I'm having a similar issue, but there is only one sheet, and the column I'm trying to pull is not my primary column. I did see it previously, but created a new report, and it's no longer an option.
The column is an email address, column type Contact list. When I was able to see it, I could select the column, but "has all of" wasn't an option in the Summarize dropdown. I need that so I can restrict visibility to the current user. Do you know why it wouldn't show up?
Thanks!
-
@Stephanie B. It sounds like you are asking two separate questions. To confirm, 1. you cannot see the column at all in a report you are creating. 2. when you can see the column, you can't summarize it.
- I would need more details to help diagnose the missing column.
- The only summary option for contact columns is "count". If instead you meant "filter", it may mean that your contact column is not properly set up. It would need to be a multi-select column type to allow you to filter by "has all of"
If you are wanting to create a "current user" report you would filter by "is one of" and "current user" as the value.
-
Hi @Katy Hall, I got it all sorted out. There was some, uh... user error involved.😁 Thanks for your reply!
-
Hi, does anyone know how I can include the primary column into the report? or is that not possible at all?
(I have the same primary column across all sheets) thank you!
Edit: I had a filter on. Sorted now! -
Please help as I cannot add Accountable owner as a column and do not understand why It will not show up. Thanks in advance!
-
@lyss15 the information you are showing here indicates that accountable owner is not a column, but rather a row. Does it have a column in the sheet you are building the report off of? If so, can you show that the column exists there?
-
thank you for your help! it pointed me to an area I missed for a column it now works, yay!!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives