Where can I find column ID in smartsheet?

Bortyk

 For row, this is very easy. But it's not clear for column. Where Сolumn ID?

Itai Perez

Hey @Bortyk,

Can you please give some more details? what do you mean by column ID? for the Bridge app?

Itai Perez

Hey @Bortyk,

Can you please give some more details? what do you mean by column ID? for the Bridge app?

Bortyk

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.

Neil Watson

Hi @Bortyk, the "List Columns" Smartsheet workflow element returns a list of column details including the column ID:

Darren Mullen

Including what Neil stated, here's a couple more in the video I made on this!

https://www.youtube.com/watch?v=lhfzkX4MKxU

SSFeatures

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.

StevenBlackburn

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.

NeilKY

https://community.smartsheet.com/discussion/comment/473679#Comment_473679

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.

StevenBlackburn

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.