Formula to create hyper link with display text defined

Jason Anderson

I want to be able to clean up/simplify how a link is displayed in a cell. 

Column A: the text I'd like to use for the link display

Column B: the long URL with lots of URL tokens, folder locations, etc..

Column C: a clean, short, hyperlink made from A&B



Example values

A: Profile

B: http://www.domain.com/peeps/folks/active/profile.php&ThisDude=2341235

C: Profile

(don't bother clicking the above link, totally made up)



Is it possible to do this with some formula structure in Column C?



I've tried escaping quotes and building an <a href...></a> structure but it just comes out as text and displays the whole HTML tag.

Thanks for any thoughts. 

Shaine Greenwood

Hello,

There isn't a way to generate a URL with a shortened display value via a formula. Currently, there are two ways of doing this:

1. Manually creating the hyperlink/display value by right-clicking on the cell.
2. Using the API to create a hyperlink with display value via the cell object: https://smartsheet-platform.github.io/api-docs/#cells

kirvis

Hi Shaine,

 

I would like to use the API to create a hyperlink in a cell to an outside URL. The API docs are however not very helpful on how I can do this.

 

Would you happen to have an example Python script for the Requests package that I could use to create a hyperlinked cell in Smartsheet?

 

I intend to use this script in Zapier.

 

Thanks,

 

Bastiaan

John Sauber

This would be a really great feature on our end as well; we use it in Excel all the time. Since Smartsheet is only on the web, you'd think a =HYPERLINK([URL], [DISPLAY TEXT]) would be a slam dunk here.

Maccaroni

This does seem like it would be a slam dunk. Any timeframe on adding this to SmartSheet?

Allison Jones

I use this all the time in Google sheets and excel - it would make my life easier for sure!

SiriusBits

As both Jason Anderson and John Sauber indicate, this is both needed and would be a slam dunk.

Ironic that I can do this in a comment...

Michael.Baker

Sigh... Feels like every community post I stumble upon plays out just like this . . .