Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Report not syncing when columns from source sheet deleted
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?
Comments
-
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!)
