Why do reports change column name for Modified by and Modified columns?

laura_bfo

I have multiple sheets I'm rolling up into a report. Each sheet has a "Modified by" and "Modified" column, except I've renamed them (in every sheet) to "modified_by" and "modified_date". However, when I create the report, it only let's me select "Modified by" and "Modified" as the column names. Why? Does anyone know a workaround so in my report, the column names appear as they do in the sheets?

Michelle Choate 2

These are system generated columns in reports. You do not even have to have them in the sheet for them to be added into a report. Because of this, the system also generates the name for them. Even though you are able to change the name of them inside of sheets, you cannot change any column names inside a report no matter the column.