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.
Sign in to see the current vote count, add your own vote, or leave a comment.
@JenniferTorres I very much agree with this and I upvoted.
Just an FYI for you though it is possible to extract the column id in a roundabout way without using bridge. If you go to card view and group the cards by the column, you will see the column id in the url. The only caveat is that if your column is not a single select dropdown you can't view by that column, so you would have to change it temporarily. However, you can change it without saving, get the column id, and then refresh the sheet but don't save.
@Samuel Mueller - thank you for sharing this!
I have to admit this is a sneaky little tip I've never thought of before... brilliant. 🙌
@Samuel Mueller Thanks so much!!
Currently, I can click File>Properties to get the Sheet ID.
I can also right click on a row and select properties to get the Row ID:
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.
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.
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:
While more technical, this method lets you view all column IDs and other sheet metadata.
@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.
I wanted to add a picture here of what the SSFeatures solution looks like:
SSFeatures lets you open a popup that shows you all of the column IDs in your sheet.
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
