How do I extract full URL from Hyperlink cell?
Options
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
-
You would need to leverage the API for this one.
Answers
-
You would need to leverage the API for this one.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!