Report Builder not showing all column options

sharon durham

I've been trying to pull in some additional columns into a report from the same sheet that the other columns are pulling from.  When I click on 'What?' in the Report Builder, it does not show all of the columns as options.  They are columns with dates and are no different than other date columns that show up as options.

 

I went back to the original sheet and added a new "test" column and it showed up as an option in the report builder... but columns that have been there from the start are not...

 

What am I missing???

J. Craig Williams

"What?" will show Checkbox, Text/Number, Symbol, Dropdown List type columns.

"When?" will show Date columns (or Date/Time system columns)

"Who?" will show Contact List columns (or contact type system columns)

 

If you are seeing 'date' columns in the "What?" list, it is likely that they are not really date columns.

 

Hope this helps.

 

Craig

 

Yasutaka Ito

Hi @sharon,

 

On your Report Builder, you would find [Run] button. Right next to it is [Columns] button. If you want to select any column(s) that are not supported by [What?], [When?], [Who?] sections, look for them in the [Columns] section.

 

Have a great day!

nsdikin

I am having the same problem as Sharon. A sheet which was built for a report received a new column in the sheet. When I go to the report and hit Run, the new column doesn't appear in the columns box nor on my options below for What, When, or Who.

I think you guys have a save glitch where the Report is not picking up columns added to the Sheet after the Report was first created and saved. This is new, I haven't had this problem since yesterday. 

lloyd

I am having the same problem as Sharon and nsdikin as well.  But, in my case it worked itself out after about 10 mins.  Perhaps, as nsdikin wrote, it is a save issue and takes some time.

Jeff Moser

+1 on the problem mentioned by lloyd, nsdikin & Sharon. This is a little frustrating considering I had added a new column to 20+ sheets needing it to roll up to the master report I had created.

McneilOMC

Having the same problem , adding in new columns to the report does not show the content from that column

This is new , have seen this working before.

chattingh2u

Following - having the same issue. 

Roger Vogt

I'm also having the same issue.  I have several reports where I need to add this new text column to the report view.  It's not showing that as a column I can select.  

David_Ferraro

Looks like this is still not fixed.

Chris A

Bump

CatherineO

I'm having the same issue as everyone else. When I add columns to the report and click RUN, the newly added columns do not appear in the report. 

Werks.Experten

Hello,

is also now shown here - Smartsheet Bug only "system coluums" are shown

Thx WE

jeflanne

I'm having the same issue.  Is this getting fixed?