Formula to create hyper link with display text defined

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.

Find more posts tagged with

Education

Formulas

Comments

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:

Manually creating the hyperlink/display value by right-clicking on the cell.
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 . . .