Where can I find column ID in smartsheet?

For row, this is very easy. But it's not clear for column. Where Сolumn ID?
Best Answer
-
Hey @Bortyk,
Can you please give some more details? what do you mean by column ID? for the Bridge app?
Itai Perez
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
Answers
-
Hey @Bortyk,
Can you please give some more details? what do you mean by column ID? for the Bridge app?
Itai Perez
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
Yes.
// Set options var options = { sheetId: 9283173393803140, columnId: 0123456789012345 }; // Delete column smartsheet.sheets.deleteColumn(options) .then(function(results) { console.log(results); }) .catch(function(error) { console.log(error); });
I want to use this code.
-
Hi @Bortyk, the "List Columns" Smartsheet workflow element returns a list of column details including the column ID:
-
Including what Neil stated, here's a couple more in the video I made on this!
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
-
I just want 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.
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.
-
Just ask the SmartSheet AI tool — it'll return the column ID values as C###########_ColumnName.
Use the number between the capital "C" (for column) and the underscore and this is what will identify the column for Bridge or API more granular development.
Steven Blackburn
- Head of Technology and US Operations, Prodactive
- Smartsheet Platinum Partner
-
I tried this and it didn't work. The AI spit out something like "C3014014321059_Primary" and I assumed "3014014321059" then would be the column ID. But it was actually similar to 6949331817156400". Both WAY different, and has 3 extra digits. So I don't think the AI knows.
-Neil
-
Might just have to run a quick python script to look up the column. I've noticed this the other day that the AI returns weird values sometimes as well. This must be tied to another identifier somewhere else. If you ran a python script that searches the worksheet id for all the columns in the worksheet, it'll return the values by title and by column id.
Steven Blackburn
- Head of Technology and US Operations, Prodactive
- Smartsheet Platinum Partner
-