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.

smart change of column name

Masha Iris
edited 12/09/19 in Archived 2016 Posts

Hi,

 

i need to change several column names in my smartsheet.

I have entire workspace built around this sheet, using it as data source. I have multiple reports that show/filter on this column, and if i simply change the name, reports stop working.

 

is there a smart way to update column name everywhere?

or somehow get a list of all reports that use this column so i can be sure i didn't miss anything

 

thanks,

masha

 

Tags:

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 04/24/16

    Masha,

     

    update column name everywhere?

    Not that I know of.

    The design of the system needs to account for this pain and have your column names fixed as early as possible. 

    I know that does not help you now.

     

    get a list of all reports?

    Again, not that I know of. I'm afraid you will need to check them one-by-one.

    You can at least get to all of your Reports from the Home tab | More | Reports window.

     

    This might be something that can be done in the API. 

    Depending on how many Reports you have, it might not be cost effective to build the first time, but it is always something to think about.

     

    Craig

     

     

     

  • Sadly, the API has no access to report builder :(

     

    i guess this will be a manuall road...

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    That's what interns are for. Laughing

     

    Craig

This discussion has been closed.