How do I extract full URL from Hyperlink cell?
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)?
Help Article Resources
Check out the Formula Handbook template!