Reports and Dashboards break if column is renamed in a Sheet
Reports and dashboards break if the columns in the source sheet are renamed :-(
It will be great if @smartsheet does not depend on the column names from the sheet when used in reports as it will then not break the reports and hence the widgets in the dashboards using those reports as source.
Comments
-
Yes! This is the most frustrating thing when we have multiple team members working on a few sheets they own to consolidate information. Next thing you know they decided to rename a column and our reports and dashboards are broken.
-
THIS! Allow a rename of a column in the source sheet changes any formula referencing that column. WHY though if a report depends on the column name does the report ask that you remove the old column and add the new column? It should be a 1 to 1 change.
-
At Engage 2022, it was mentioned and announced that this enhancement is completed and fixed!! YEY!! Thanks Smartsheet for addressing this. 🙏
-
@Sameer Karkhanis Have you gotten this to work yet? I remember the announcement and rewatched the portion where the feature was announced, but I cannot get it to work.
-
@Russell.Culp When I tested it did not work for me. I renamed the column in the sheet but it did not reflect the same in the report and also the original column in the report displayed blank data after renaming (in the sheet). So I suppose there is some issue still there. Haven't tested the dashboard use case.
-
Looks like the report and dashboards don't break but the data/content shows blank for the renamed column. Also the new name of the column does not show up in the report. Definitely needs a fix.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Can I link a Smartsheet report in a form. My form will be for a person to confirm info from a report is correct. So I want the user to be able to view the report while filling out the form.
- I have 4 sheets used by individuals to track their work. I have a report that pulls from all 4 of those sheets to give me a total count of items they listed for the month as well as each line item (de…
- Hi All! Quick question - I am working on a form with a lot of yes or no questions, and I decided to display them as horizontal radio buttons. They are all circles except for one question, which shows …
