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, smartsheetguru.com
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, smartsheetguru.com
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, smartsheetguru.com
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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!