Pivot Sheet Column Name Changes
Greetings -
I'm experiencing some inconsistencies between my Pivot Sheets relating to column name changes. The pivot process adds "Grand Totals-SUM-" as a prefix to the column name. I remove it and run the process again. The pivot process works fine on some sheets (data loads as-expected). However, brand new columns are inserted on other sheets with the "Grand Totals-SUM-" again. I rename them one more time and run the process ... same results. I cannot seem to find the rules for renaming the columns. I did see a suggestion for using helper columns pointing to the source, then hiding the source columns, but I don't want to do that if I don't have to.
Thanks in advance!!!
Best Answer
-
What you're describing sounds like unexpected behaviour; after you adjust column names in your destination Pivot sheet, these column names should stay what you re-named them, even as new rows are added in the original source sheet.
There was an issue where columns were added in again if the data became zeros, however we deployed a fix for this at the beginning of October. If you are still seeing this behaviour, please contact Smartsheet Support and provide screen captures (or, if possible, a screen recording) of the old columns being inserted again.
Thank you!
Genevieve
Answers
-
What you're describing sounds like unexpected behaviour; after you adjust column names in your destination Pivot sheet, these column names should stay what you re-named them, even as new rows are added in the original source sheet.
There was an issue where columns were added in again if the data became zeros, however we deployed a fix for this at the beginning of October. If you are still seeing this behaviour, please contact Smartsheet Support and provide screen captures (or, if possible, a screen recording) of the old columns being inserted again.
Thank you!
Genevieve
-
Got it. I tried this again and it seems to be working now ... must have been a fluke.
Thanks for the help!!!
Andy
-
Very strange! Glad to hear it's working now though.
