Sheet Summary Report - does not include all columns from source sheet

Wade2 Mattinson

I have created a sheet with multiple columns including some drop downs and symbols. When I try to make a Sheet Summary Report, I select my source data sheet and expect to see all the columns from that sheet. Instead, I the only options are "Created" "Created By" "Modified" and Modified By"

Can someone help me figure out how to include the columns from my data sheet and even better, why is this happening? Is it some setting or sheet configuration. I have not had this issue in past experiences with Smartsheet.

Stefan

Hi @Wade2 Mattinson ,

a report from a sheet can be created either as row report, or as sheet summary report.
You are asked about the type, when you create the report.
only the row report allows you to access all columns in your sheet.
Summary fields are separate cells in the same sheet to be found on the right side of the smartsheet window under “Sheet summary report”.

Hope this helps

Stefan

Alan Lugton

I have the same problem - it is definitely a Sheet report we need as I created it previously on another template. When I am trying to replicate - everything is as it should be,

except the options are not available. E.g. I have a Status column with dropdowns for Not started, in progress, complete, etc. I use the sheet summary report to show a count of how many time each status appears.