Automatic Hyperlinking

Abdul Tahlil · 10/10/22

Hi,

I have been investigating whether Automatic Hyperlinking is something that can be done within Smartsheet.

For example: A hyperlink in Column A and text in Column B, Automatic Hyperlinked Text Column C.

The consensus seems to be that this feature doesn't exist or can't be implemented. Has anyone found a work around?

Thank you.

Genevieve P. · 02/28/23

I agree with Ryan! If you want to use a formula or some other way to get a URL, it will need to be displayed as a full URL in the cell in order for it to be clickable. There currently isn't a way to hide a link behind display text in an automated manner.

Please add your vote and situation to this Product Idea post to let the Smartsheet Product team know that this is a feature you would like to see implemented in the future:

HYPERLINK Function

unknown

Sep 2, 2022

Hi @Genevieve P., @Paul Newcome,
Cc: @Art Schneiderheinze, @AJW, @Andrée Starå
Are we any closer to getting a HYPERLINK() function in Smartsheet?
Something with a familiar syntax such as...
= HYPERLINK( Link_URL, [Display_Label] )
I know this has been discussed on many old threads, but I have been able to calculate a formula based on Sheet column data values to calculate a clickable URL – just not a one with a neat Display Label however! I use:
= "https://domain_name.sharepoint.com/library/" + [Folder Name]@row
It will display the full https:... text, but at least it is clickable.
If the URL root is the same for all items in the sheet, then I create a Sheet Summary field called "SharePointURL" (or "FolderURL", or something like that) and change the column formula to be...
= SharePointURL# + [Folder Name]@row

Cheers,

Genevieve

Ryan Sides · 10/10/22

Hi Abdul,

You should be able to use the formula in column C to create the hyperlink...

Is that not working for you?

Ryan

Genevieve P. · 02/28/23

Hi @Abdul Tahlil

I agree with Ryan! If you want to use a formula or some other way to get a URL, it will need to be displayed as a full URL in the cell in order for it to be clickable. There currently isn't a way to hide a link behind display text in an automated manner.

Please add your vote and situation to this Product Idea post to let the Smartsheet Product team know that this is a feature you would like to see implemented in the future:

HYPERLINK Function

unknown

Sep 2, 2022

Hi @Genevieve P., @Paul Newcome,
Cc: @Art Schneiderheinze, @AJW, @Andrée Starå
Are we any closer to getting a HYPERLINK() function in Smartsheet?
Something with a familiar syntax such as...
= HYPERLINK( Link_URL, [Display_Label] )
I know this has been discussed on many old threads, but I have been able to calculate a formula based on Sheet column data values to calculate a clickable URL – just not a one with a neat Display Label however! I use:
= "https://domain_name.sharepoint.com/library/" + [Folder Name]@row
It will display the full https:... text, but at least it is clickable.
If the URL root is the same for all items in the sheet, then I create a Sheet Summary field called "SharePointURL" (or "FolderURL", or something like that) and change the column formula to be...
= SharePointURL# + [Folder Name]@row

Cheers,

Genevieve

Abdul Tahlil · 03/02/23

@Genevieve P. @Ryan Sides Thank you both. Very helpful!

Formulas and Functions

Formulas and Functions

Automatic Hyperlinking

Best Answer

HYPERLINK Function

Answers

HYPERLINK Function

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Created Date of Row Copied from Another Sheet

Need to update dates to Q1_2025, Q2_2025, Q3_2025, Q4_2025

Writing a reference formula with multiple IF/AND situations