Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
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.
Comments
-
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
-
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
-
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.
-
This does seem like it would be a slam dunk. Any timeframe on adding this to SmartSheet?
-
I use this all the time in Google sheets and excel - it would make my life easier for sure!
-
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... -
Sigh... Feels like every community post I stumble upon plays out just like this . . .
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 436 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- I'm trying to create a SUMIF formula that looks at the salesperson name in a column and adds up or totals their $ sales in another column. To ultimately show in Dashboard of Totals Sales by Salesperso…
- I have a Dynamic View that is filtered using the "Restrict view by sheet filter" so the view only shows a certain users assigned projects. Each project has one or more resources. The "resources" colum…
- Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…