A way to place the Row ID (for APIs) into a cell value with formula?

KGuyer · 01/14/22

For clarification, the ID I am after here is the Row ID you can view in the properties of a row. I'd like to be able to do something like have someone export a sheet and send it to me for processing, and have a pointer directly back to which records there might need a resulting update, to be done via automation, that would use the Row ID (not auto-number) in the API call.

To do this it would be simpler to have the Row ID as a value in one of the cells, but there is no =[RowID] kind of formula I can find. Is it possible to have the Row ID appear as a value in a cell in the parent row? Otherwise I need to pull the entire sheet down and search for the target row based on other criteria (like the auto-number) just to get the Row ID, then make another API call to update it. Possible but not really efficient if their export can contain that Row ID initially. Thanks!

MattW · 01/18/22

Been looking for this also. Thread after thread asks for it and it doesn't seem to be possible, unless it's been added very, very recently. People use external tools that link to smartsheets like Zapier and MS PowerApps just to extract this and then stick it back in a column, but it does not seem to be possible to do it within SmartSheet directly.

Julio S. · 01/19/22

Hi @KGuyer ,

There isn't currently a specific function that returns the rowID. When you have a moment, please let our Product team know about your feedback by filling in this form, here. Thank you!

As @MattW mentions, a possible way to automate this would be to use a third party tool that uses the API to return all rowIDs within a sheet (by making a GET sheet call for example) and then collect the rowIDs and post them back within the sheet as needed. I'd refer to https://smartsheet.redoc.ly/tag/sheets#operation/getSheet from the API documentation if this sounds like a possible solution.

The other way to obtain the rowID would be to manually collect it from the row properties and paste it to the relevant cell but I understand this can be a tedious task in voluminous sheets.

I hope this can be of help.

Cheers!

Julio