Report not syncing when columns from source sheet deleted

tylermh

Does anyone else experience the glitch where the columns on a report that were originally added with the report builder, but then deleted from the source sheet at a later point, are still showing up on the report as orphaned/inactive columns?

Bruce Leban

It's not a glitch. If a column is deleted from all sheets referenced by a report, it will show up marked "(column not found)" in the report builder. Columns are not removed from reports automatically so that the report admin has control over that. They may want to re-apply the criteria on the deleted column to a different column and if it was removed automatically they wouldn't be able to see that. And if that column is added again to one or more of the sheets in the report they will once again show up in the report. (And imagine what would happen if a user was accidentally removed from a workspace and they had reports against that workspace. If we auto-removed the columns, those reports would have all of their criteria deleted, which would be a very undesirable result!)