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

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

Hi,

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?


Thanks,
Mark

 

Tags:
· Share on FacebookShare on Twitter

Comments

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

    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?

    Richardr 

    · Share on FacebookShare on Twitter
  • Mark Bonham
    Mark Bonham ✭
    Options

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

    · Share on FacebookShare on Twitter
  • Travis
    Travis Employee
    edited 08/31/15
    Options

    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).

    · Share on FacebookShare on Twitter
  • Jacob D
    Jacob D ✭
    edited 10/06/16
    Options

    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?

    · Share on FacebookShare on Twitter
  • Ron42na
    Ron42na ✭✭✭✭
    Options

    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.

    · Share on FacebookShare on Twitter
  • Doug Carr
    Doug Carr ✭✭✭
    edited 05/17/17
    Options

    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?

    · Share on FacebookShare on Twitter
  • Kelly Ospina
    Kelly Ospina ✭✭✭✭✭
    Options

    I also vote for this feature. 

    · Share on FacebookShare on Twitter
  • Vic P
    Vic P ✭
    Options

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

    · Share on FacebookShare on Twitter
  • Ramzi Khuri
    Ramzi Khuri ✭✭
    Options

    +1 vote. Critical Feature

    · Share on FacebookShare on Twitter
  • MR
    MR ✭✭
    edited 03/17/19
    Options

    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.

    · Share on FacebookShare on Twitter
  • Jack Clarke
    Jack Clarke ✭✭
    Options

    +1 for this feature

    · Share on FacebookShare on Twitter
  • aramirez
    aramirez ✭
    edited 08/22/19
    Options

    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

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories