Formula to Hyperlink contents of a column into another

Hello,

I have two columns, one with a URL, and one with text. Is there a formula, or automation / process that can hyperlink the URL and text into a new column?

I have the need to hyperlink a few hundred rows of data and want to avoid the manual hyperlink method (copy URL, cmd K , paste link etc...)

Find more posts tagged with

Formulas

Accepted answers

Darren Mullen

@Matthew_Lanterman Ahh, so really you want to give a "friendly" name to the hyperlink.

The only way to do that is through an API script. Smartsheet doesn't have a formula to do that sort of operation in a sheet directly.

All comments

Darren Mullen

"I have two columns, one with a URL, and one with text. Is there a formula, or automation / process that can hyperlink the URL and text into a new column?"

Do you want to concatenate these, or what are you trying to do with the URL and Text?

Matthew_Lanterman

@Darren Mullen - I want to see if there is an in kind function or process in Smartsheet that does what the =HYPERLINK() function does in Excel.

Darren Mullen

@Matthew_Lanterman Ahh, so really you want to give a "friendly" name to the hyperlink.

The only way to do that is through an API script. Smartsheet doesn't have a formula to do that sort of operation in a sheet directly.

Matthew_Lanterman

@Darren Mullen - noted. Thank you confirming!

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.