report not showing all columns from a sheet

LBou

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?

Paul Newcome

Is it your Primary Column?

LBou

It is not my primary column in the report

Katy H

It looks like you are filtering more than one sheet into the report, does Group Request ID exist in both sheets?

LBou

Yes, Group Request ID exists in both sheets

Katy H

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.

LBou

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.

Katy H

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.

LBou

That worked, thank you!

Stephanie B.

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!

Katy H

https://community.smartsheet.com/discussion/comment/426903#Comment_426903

@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.

1. I would need more details to help diagnose the missing column.
2. 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.

Stephanie B.

Hi @Katy Hall, I got it all sorted out. There was some, uh... user error involved.😁 Thanks for your reply!

Leslie_gs

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!