Sign in to submit new ideas and vote
Get Started

Column ID visible in Column Settings

Options
JenniferTorres
JenniferTorres ✭✭✭✭

The column ID has been removed from the Column Settings. It is now accessible only through Bridge. I would like to request that it be added back to the Column Settings.

Tags:
20
20 votes

Idea Submitted Β· Last Updated

Comments

  • @Samuel Mueller - thank you for sharing this!

    I have to admit this is a sneaky little tip I've never thought of before... brilliant. πŸ™Œ

    Need more information? πŸ‘€ | Help and Learning Center

    こんにけは (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!πŸ‘‹ | Global Discussions

  • JenniferTorres
    JenniferTorres ✭✭✭✭
  • Kevin P Scott
    Kevin P Scott ✭✭

    Currently, I can click File>Properties to get the Sheet ID.

    image.png


    I can also right click on a row and select properties to get the Row ID:

    image.png

    But it takes some API sleuthing to get a Column ID. It would be really great if I could right click on a column and get the Column ID.

  • Samuel Mueller
    Samuel Mueller Overachievers Alumni
    edited 02/27/24

    This is a much needed enhancement. I've mentioned this somewhere before, but you can access column ID if you navigate to card view, it's in the url.

  • Frank Geraci
    Frank Geraci ✭✭✭

    If the column isn't available in Card View, you can find the column ID by inspecting the network requests in your browser's developer tools. Here are the steps:

    1. Open the developer tools (usually F12 or right-click > Inspect or View > Developer > Developer Tools).
    2. Go to the Network tab and filter for 'loadSheet'.
    3. Find the request titled 'home?formName=ajax&formAction=fa_loadSheet' and inspect its response.
    4. Search for 'jsdSchema.ajaxMegaBulkRecordInsert([jsdSchema.TABLE_INDEX_GRIDCOLUMNDEF'.
    5. This data contains the column title, description, column ID, and other information.

    While more technical, this method lets you view all column IDs and other sheet metadata.

    Selected April 23 2024 14_43_56.png


  • Darren Mullen
    Darren Mullen Community Champion
    edited 01/24/25

    @Samuel Mueller @Frank Geraci Those are some cool tricks that I didn't know about! I came across this post when I was doing some research for my video on alternative ways to get Smartsheet Column ID's.

    You're methods are good for those that don't want to deal with the API or use any additional tools.

    Here's my list of 3 ways.

    Darren Mullen, Author of: Smartsheet Architecture Solutions

    Get my 7 Smartsheet tips here

    Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite

  • SSFeatures
    SSFeatures ✭✭✭✭✭✭

    I wanted to add a picture here of what theΒ SSFeaturesΒ solution looks like:

    image.png

    SSFeatures lets you open a popup that shows you all of the column IDs in your sheet.

    Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)

    SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: β€” Auto Sorting β€” Sorting with Filters β€” Report PDF Generation β€” Copy and Paste Conditional Formats β€” Copy and Paste Automation Workflows β€” Column Manager β€” and so many more.