Return Row ID / Row link in cell?

Rob W.

Hi all,

Looking to leverage a function that clearly exists in Smartsheet, but doesn't appear to be a user-side feature:

Application:

I have a report with two sources. Essentially one is an intake log generating new 'Change Request' UIDs, whereas the second source is approved requests which are given 'Change Order' UIDs. I have an index(collect()) column formula in both sheets that allows us to cross-reference the UIDs.

Problem with current state:

Currently the UIDs are hyperlinks where they are the source sheet, but text only for the index(collect()) reference. Users have to find the order, see the UID for the request, then go navigate to the request in the report, then follow that hyperlink to the source sheet, or manually look this up directly in the source sheet.

Returning a hyperlink for the indirect reference would streamline navigation considerably since we're dealing with a high volume of records.

Request:

Address to the row link or row ID property via some formula / function in a cell so that cell value can be displayed via index(collect()) in locations where this row is relevant, but indirect.

Feels like this should just be a standard shell function =@rowID or =@rowlink

Evidence:

In properties, each row in a sheet has a unique Row ID and Row Link.

When I run a report, the native 'Sheet Name' column displays a hyperlink that is not only to the source sheet, but directly to the sheet row from which the report is pulling. I assume this is addressing to the Row Link.

I've seen some threads suggesting to manually copy the row link to a cell on that row, which would technically work, but is absolutely not scalable or automated and therefore a no-go.

Thanks in advance for any ideas / suggestions!

Paul Newcome

If you want this to be populated automatically, you would need to use the premium add-on Bridge (maybe), the API (definitely), or some other similar 3rd party application (maybe).

Rob W.

Thanks for the reply, Paul!

We have the gold package, but haven't been set up for Bridge yet. I've reached out to our CRM to get this turned on, but don't fully understand your comment.

I'll take a look at Bridge once we get this access configured, but I'm unclear what you mean by 'the API'. If this is intra-Smartsheet functionality, I'd assume that no API is needed to support unless you're unsure if Bridge will entirely do the trick here and that's why an API and 3rd party application may be needed.

Paul Newcome

I feel like Bridge should be able to do it, but I am not 100% certain.

I do know that the API can though if Bridge cannot.