Finding Column IDs in Smartsheet

SSFeatures provides a simple popup to find all of the column IDs for your sheet or report.

The Problem with Column IDs in Smartsheet

Column IDs are essential when using Smartsheet Bridge, Data Shuttle, or the API. According to Smartsheet's own instructions, retrieving a single column ID involves nine cumbersome steps, including executing an API call.

While Smartsheet provides an interface to view sheet IDs and row IDs, there’s no similar feature for column IDs. This forces users to rely on manual workarounds that are tedious and time-consuming for something that should be quick and intuitive.

Users have been forced to use tedious workarounds with API calls, browser developer tools, Smartsheet Bridge, and make.com integrations. This is a confusing user experience and wastes too much time.

Feature Request: Column ID visible in Column Settings
Feedback: "I very much agree with this and I upvoted... This is a much needed enhancement." - Samuel Mueller
Hacky Workaround: Use browser developer tools, refresh the page, view the network tab for the ajax "fa_loadsheet" response, then search for the jsdSchema response, which contains the column IDs.
Hacky Workaround: Use "Make.com" which allows 1000 free scenario runs. Follow 12 steps to setup a scenario that runs the "Get A Sheet" scenario for your sheet ID, then view the response which contains the column IDs.
Hacky Workaround: Use Smartsheet Bridge to trigger the "List Columns" workflow. Then dig through the response until you find the ID for the specific column that you are looking for.

The Solution with SSFeatures

SSFeatures provides a "View Column IDs" button, offering a simple and efficient way to access all your column IDs. With just a click, this feature opens a popup displaying the column IDs for your sheet or report. This eliminates the need for Smartsheet's complicated instructions or the tedious workarounds discussed in the Smartsheet Community forum.

Find column IDs popup

Demo Video

Frequently Asked Questions

Can you tell me more about the security and privacy of this feature?
- Absolutely. SSFeatures operates entirely within your browser, directly calling Smartsheet's application code. No data from your rows, columns, or cells is ever sent to our servers, ensuring your data remains private and secure.