Creating a sheet summary report

Mona Patel

I am trying to create a report, picking the project plan sheet. For some reason, list of columns to pick are only showing up with 5 (created, created by, modified, modified by and Status override), no other columns are listed. I cannot figure out why it is not allowing me to pick all of the columns that are in the selected project plan sheet.

Heather Duff

Hi Mona,

Does the source sheet have Sheet Summary fields? If not, you'll want to use the Row Report or create a separate summary sheet with formulas to summarize your data.

If you want to provide screenshot(s) with any sensitive information blacked out, it may help go into further detail.

Best,

Heather

Mona Patel

Hi Heather,

That was it, you answered my question. Thank you so much.

-Mona

Heather Duff

Happy to help! Best of luck.

topazfae

I am not sure - I have the same issue 0 only one sheet showed up but I have 30 sheets. I am not sure where to "enable Sheet Summary field"? on the source sheet?