Sheet summary report not showing all columns

VL0001

So i was trying to edit a sheet summary report that was built from someone prior to me and i was struggling to make the necessary changes so ive made a new summary report, however, i am running into the same issues. For some reason the column options in the sheet summary report are not all of the options that should be available from the sheet. Also, somehow the titles are different on a few of them.

The first picture below is of the options in the sheet and the next 2 pictures are of the available columns in the report. I dont understand why approved ACR amount from the sheet is showing up as ACR Amount in the report and why some of them are missing such as Committed Spend (PO Total).

Any help would be appreciated!

ChristianFinke

Hi @VL0001

The issue is most likely one or two things. First, the Sheet Summary reports pull from the Sheet Summary section, not the main sheet columns. Make sure fields like “Committed Spend (PO Total)” exist in the Sheet Summary, not just in the main columns. Two, name differences may come from renaming fields in the Sheet Summary or report settings. Review the Sheet Summary section for all needed fields with consistent naming, then update the report to match.

VL0001

Is the sheet summary section just the section in the sheet indented and below "Summary"? If so then it does exist as seen in the first picture but not in the column options in the report in the next 2 pictures.

I now have it linked to only 1 sheet summary so that the naming is consistent and it is still giving me options in the report that dont exist in the sheet summary. Would updating the report just be hitting refresh or am i missing something?

Paul Newcome

Try creating a Row Report instead.