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

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?

Best Answer

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭
    Answer ✓

    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.

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with!

Answers

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭
    Answer ✓

    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.

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with!