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

Find more posts tagged with

hyperlink

Cell linking

Salesforce Connector

URL

Links

Accepted answers

Paul Newcome

You would need to leverage the API for this one.

All comments

Paul Newcome

You would need to leverage the API for this one.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.