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 Column Names / Labels are not same as Smartsheet Column Names

Mark Bonham
edited 12/09/19 in Archived 2015 Posts


I have noticed on reports created from the original smartsheet that the Primary Column Label and automatic numbered columns don't have the same smartsheet column name.


When you pick the reporting you want to include it uses the original default titles as opposed to column titles used in the smartsheet (if you have changed this to a title which is business required)


Created By

Modified by


However if you renamed these, when you create a report the only option is to use the default title. 


Has anyone got a workaround for this?




  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭
    edited 08/28/15

    In your report, where you see "Primary Column" as your title. Double click on the title and you can rename it back to whatever you want it to say.

    Hope that solves the problem?


  • Thanks Richard, yes that works for the Primary Column, unfortunately not for the other columns in the report.

  • Travis
    Travis Employee
    edited 08/31/15

    Mark, every sheet contains a primary column and while these may be named differently across sheets, they will all appear in the same column in a report (unlike other column types with different names). This is why it will default to "Primary Column" in the report but as Richard suggested, this can be changed by double clicking on the column header. At this time, there is not a way to change column headers in reports for any other column (including system columns).

  • Jacob D
    Jacob D
    edited 10/06/16

    Hi Travis,


    Has there been any change since your post last year?


    The ability to change column headers in reports for other columns is extremely important because the data is being pulled from summary calculations in another smartsheet and being displayed in Report format in our "Sights".


    FYI - The summary calculates column totals from a "Purchase order" column using SUMIFS, but if we put the calculation in the same column as the "Purchase Order" Column, there will be a circular reference. How might we get around this issue?

  • Ron42na
    Ron42na ✭✭✭✭

    Any movement on this one?  For me, having the ability to rename all column headers in reports is pretty important - so I can tailor the report to different user groups.  As it is now, I have to create different columns for each user group - it works, but it's a pain and makes sheet/report maintenance that much more of a hassle.

  • Doug Carr
    Doug Carr ✭✭✭
    edited 05/17/17

    I agree. This is an extremely important feature. I just started using Smartsheet and I came across this issue within minutes of building my first report. That's how often and important this capability is.


    Any update on if this has even been added to a list of possible future enhancements?

  • Kelly Ospina
    Kelly Ospina ✭✭✭✭✭

    I also vote for this feature. 

  • I need this... super important feature that will improve the user experience.

  • +1 vote. Critical Feature

  • MR
    MR ✭✭
    edited 03/17/19

    Hi, upvote from my side too.

    I want to be able to rename column in report and then it should give me the option if I want to rename only for the report or I want to rename back columns in the sheets. I am implementing smartsheet, have defined templates, but sometimes people dont follow the template or I want to modify the template as I get more experience with it. Then instead of going in every individual sheet to change the name or set the column type, I should be able to do this via report. This would add further to the benefit of smartsheet of having editable content in the report. Then you can also edit the file structure from one place. Right now manually editing structure of individual sheets might still be possible, but as time goes by we will be handling hundreds of sheets created from defined template in the company.

  • +1 for this feature

  • aramirez
    edited 08/22/19

    The ability to rename column titles or headers in reports (not in the original sheet) is extremely important.  I am talking about all columns not just the primary column and again just to make clear, I am talking about renaming column titles in reports not in the original sheet.

    I can see there are multiple requests for this feature just on this blog.

    Has there been any update on this feature . . .  ?

    Thanks in advance.


    Al Ramirez


This discussion has been closed.