Report Keeps Saying "Column Not Found"

I have my sheet set up and saved. Then, I created a report based on columns in the sheet. I added the following columns, saved the report. Data already in the sheet was showing in these columns.

Now three times, I've opened the report, and these columns keep showing up as Columns Not Found. I unchecked the columns and added them again to the report. The names have NOT changed or deleted or renamed.

If I look at the columns in the report (see below), the data is still showing up even though I have those error icons in the dropdown..

So I don't understand why the dropdown is showing these columns as having errors.

Find more posts tagged with

Accepted answers

All comments

AngB789

Are you pulling in only 1 source sheet to the report?

Paul Newcome

Even if the source column got renamed, it will still show the data in the report along with the old column name. If the source column in the sheet was renamed, then the name was changed back to the original name, it will still bug out.

Instead of unchecking the columns, click the "x" next to the column name in the top part of the column selector, be sure to click the "OK" button to confirm everything, save the report, refresh your browser, then open up the column selector again. You should be able to re-add those columns now without the error.

If that still persists and you only have a single source sheet, I would suggest reaching out to Support. If you have multiple sheets, double check all of them. When I have this happen, one of the first things I do is go to the activity log of the source sheet(s) to see if it was possibly renamed then had the original name put back just so I know what I am dealing with.

aschneiderheinze1025

Yes, just one source sheet.

aschneiderheinze1025

I did what you suggested, then I saved the sheet, closed the tab, and re-opened the report. Those columns appear again as Column Not Found. And I haven't even opened the source sheet yet today.

Paul Newcome

Have you tried recreating the report from scratch to see if maybe there is some kind of bug in that report? You may end up having to reach out to support.

aschneiderheinze1025

I re-created the report, saved, closed, and re-opened the report, and I'm not getting the Columns Not Found issue. This may have been a good recommendation —- I'll keep an eye on it, and I'll let you know if this "solved" the problem.

Paul Newcome

Hopefully that's it. I would still reach ou tot support to try to find the root cause to hopefully avoid it happening again in the future.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.