How do I extract full URL from Hyperlink cell?

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)?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!