Welcome!

What is the easiest way to find a Column ID?

Luis Salguero

I need to find the Column ID for a Bridge workflow for a column named Second_receiving_list.

I've clicked everywhere to no avail.

Thank you,

Luis

Find more posts tagged with

Comments

Diana Yeh

Hi @Luis Salguero,

This is a great question! To find the column ID in Bridge, you can use the Get Row module under Integrations>>Smartsheet in your workflow to find the column IDs.

Once you've successfully added the Get Row module to your workflow with the respective fields, trigger the workflow (whatever your trigger is, go ahead and make that action occur). Once the workflow runs, the Get Row module will return information in the Activity Log, including the column ID.

Screen Shot 2021-07-30 at 10.23.19 AM.png

Screen Shot 2021-07-30 at 10.23.31 AM.png

Best,

Diana

Ward.Hively

I know this is an old post put to future inquiries... Unless a better alternative exists... Make.com offers a "Get Sheet" module. Make features a free account with up to 1,000 free module runs. Pretty simple UI to navigate and it does the job.

Simply:

Create A Scenario
Favorites
Type "Smartsheet"
Select the Smartsheet icon
Select "Get a Sheet" and authenticate connection to SS
Grab your Sheet ID (Assuming if you're asking for column ID's you can find Sheet ID)
Paste into Sheet ID field
Select "Ok"
Right click the Module
Select run module only
Open the numeric bubble in the top right
Expand the Columns field

There ya go!

SSFeatures

The easiest way at the moment is by using SSFeatures.

With SSFeatures, click this "Find Column IDs" button.

And then you'll see a popup that shows you all of your column IDs.

Hope this helps!

Lindsay Whitbread

I agree with Nathan, grabbing column IDs from within the Smartsheet app itself is the most intuitive, quick option, when you're not needing to grab the ColumnID programmatically.

The InfoSpark team were so impressed with SSFeatures when we found out about it that we immediately bought a seat for every developer and consultant, and signed on as a partner!

In my opinion, every Smartsheet power user, and especially every Bridge or integration developer should have SSFeatures installed. We've got a coupon code that you can use for 20% off your order. Use INFOSPARK at the checkout to get that.

The only problem we have with SSFeatures is that it should have been developed 3 years ago :)

Lindsay

Sign in to join the conversation!

Quick Links

Trending discussions

Row ID for row created in the previous module is coming back as not existing.
I'm running into an issue in Bridge where a row I just created via the Add Row module, is coming back as not found when I try to use a Get Row module, referencing the row it just created. Goal: I have a workflow where I am adding a row to Sheet B, by copying data from sheet A. When that new row is created, an Auto Number…
How to remove rows from a DataTable using DataShuttle when the source sheet has rows removed?
I have a DataTable that is currently populated by a DataShuttle. When I upload the source report to a sheet, the data gets added into the DataTable via DataShuttle. The DataShuttle is configured to "add rows when added to the source file" and "update rows as they change in the source file". The unique column identifier is…
Data Shuttle: Duplicated Data with Different Creation Dates
Hello! I am working on a new Data Shuttle workflow and have come across an issue I haven't encountered before. I have to run an annual audit on a list of employees through a third-party site. I am able to download the query results of the audit from the third-party site, and I would like to use Data Shuttle to add results…