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...)
Best Answer
-
@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, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers
-
"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?
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@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.
-
@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, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen - noted. Thank you confirming!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!