HYPERLINK Function

West_Of_Weston

We need this

LucasJ

+1.

Currently using a dynamic url based on values from another column and it would be nice to have a HYPERLINK formula so that users can see a custom display text instead of the very long URL.

Jamie Ide

Was surprised you cannot even do this with DataMesh - would save a lot of frustration to add this! Hyperlinks are pivotal to larger organisations utilizing different domains within the solution.

AMartin

Agree - please add this function!

AMartin

Agree - please add this function!

EJH

A hyperlink function similar to excel would be extremely helpful. I'm struggling with a hyperlink that contains a portion of another cell and have it display a short name rather than the full URL.

zaf

I am creating a new column right next to predecessors and trying to get this function:

=IF(ISBLANK([Predecessors]), "", HYPERLINK("#row=" & REGEXEXTRACT([Predecessors], "(\d+)"), "Go to Row " & REGEXEXTRACT([Predecessors], "(\d+)") ))

For fast navigation.
And I believe we dont have this function yet. Please implement this feature

JenO

I'm an upvote for this to. I'd also love to be be able to automate linking a row hyperlink into a cell on another sheet. This would enable a user to be able to go directly to a linked task by clicking the link that is listed in a report.

Adrian Mandile CHESS

Hi All,

It's been over 2 years since I first posted this improvement suggestion, and I can't recall ANY new intrinsic functions being added to Smartsheet since then.

I have been told that the full architectural rewrite of Smartsheet – including the new, larger, faster, Table View – will provide the ability to extend features such as more functions. Now that Table View has landed (albeit in very beta mode) in EAP, I am a little more hopeful that we may soon see some positive movement on this front.

PS: I especially liked @MaaikMeijerink's suggestion to include an optional button/image link in the parameters. I'd suggest the syntax should be something like:

=HYPERLINK( Link_URL, [Display_Text], [Button_Link] )

The Button-Link could potentially be something selectable from the new File Library feature of the workspace, some other image file URL, or even simply "0" for a raised/bevelled colour-formattable cell area type button.

@Genevieve P., are there any updates to roadmaps on more functions, including others mentioned above, such as TEXT() and INDIRECT(), or even other useful functions found in Excel, such as CODE(), CONCAT() which allows for non-contiguous columns unlike JOIN(), PROPER(), EOMONTH(), CHOOSE(), UNIQUE(), etc.?

Trang Turtletraxx

I think this is function is much needed especially for those of us creating URL query strings. To link the query string into alerts and notification, it looks horrible and confusion as an end user seeing a VERY long URL.

Jayy S.

I would love to have this function! Has there been any movement about this?

RhondaRhocks

I was able to accomplish this at another time in my career by having a FedEx tracking # in one column and a link to the tracking URL in another and send a combined link to the recipient—all automatically.

If only I had posted the solution back then (2020). I'm very close using this:

<a href="https://example.com/">Example</a>

Keeping this feature request alive. And will post here if I solve.

John Sauber

It is crazy that this is not available.