Reports should auto-update when column names are changed.
Currently, renaming a column in a sheet will corrupt any reports that reference that sheet column. Reports should reference the backend column ID and not the column alias in the UI.
Sign in to see the current vote count, add your own vote, or leave a comment.
It would be so nice if any adjustments that are made to column names or types didn't require me to go in and adjust all the reports that I've created! Especially since there is nothing that shows what reports are tied to which sheets other than going through each and every one or finding errors.
I thought it was announced at Engage that this issue had been fixed, but it has not.
This capability was announced at Engage 2022. It was the feature that got the biggest ovation at the conference. Haven't heard any timing other than “Soon”. I've been struggling with sheet/report column names since my first experience with the issue in 2011.
And still isn't fixed.....
This is closer than you think. I have seen many updates that this is in the works right now.
@jasonp, can you point us to any such reassuring sources? It seems this "official thread" is where Smartsheet would provide updates if there was anything hopeful to report.
In the winter edition of Smartsheet Lately.
https://www.smartsheet.com/content-center/product-news/product-releases/product-highlights-winter-2023?utm_source=marketo&utm_medium=email&utm_campaign=product-highlights-2023-02&mem=button&mkt_tok=NDY0LU9OTS0xNDkAAAGJ1yAJAQ6mmfQUlYDTCySf8cPrB5junpWiAXxw876rJaMbQSlxHBvUs6GQeo6Ggky20TqePhyRZiOcoG1W-iA22BnAZ6zjyjgVaOqZ5cJuGmILSt-8
This help article makes it sound as though the functionality is already working. Anyone know why we’re not seeing these new icons on our reports? Nothing is said there about needing to configure access to it on the admin side.
https://help.smartsheet.com/articles/2482752-renamed-columns-underlying-sheets
I was sure this was working late last week, but seems they must have rolled back this feature.
When you have an extensive ecosystem of projects up through the portfolio level using control center and other premium apps like bridge and data shuttle, it would help if any change to a column in a source sheet would then change any associated reports, dashboards, etc. The cells already display any link in's and out's. There should be a way to identify when a column is pulled into a report, summary, pivot, bridge flow, part of a data shuttle offload, etc. so those downstream changes can be made automatically.
-
Welcomed addition this, love that it shows the icon to inform you what changed and to quickly disconnect if need be.
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
