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…