How do I extract full URL from Hyperlink cell?

Bruno Menezes

Hi all

I have this Opportunity ID column in my sheet that's connected to Salesforce. All cells are hyperlinked with the opportunity in Salesforce. This column is created like this by the Salesforce-Smartsheet connector and it's handy because of the hyperlink.

I need to send the Salesforce URL to another sheet, but if I link the existing column it'll show only the display text (i.e. the Opp ID) without the hyperlink in the destination sheet.

How can I extract only the full URL from this column (so I can link it to another sheet)?

Paul Newcome

You would need to leverage the API for this one.

Paul Newcome

You would need to leverage the API for this one.