Formula to Hyperlink contents of a column into another

Matthew_Lanterman

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

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.

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!