Text Display for multiple links

Gaurav Chauhan

Hi Team,

I can see the Smartsheet Cell supports with multiple weblink pasting. Upon pasting, they dont loose their property and are directed to their sites

However below are for examples only. Generally the other urls have a long thread.

We can use Text Display function for 1 link, but when I am trying this with 2 or more, it is not supporting.

Please confirm how this would work?

AdamSYNH

Hi @Gaurav Chauhan,

If not done so already, upvote this: Ability to add functional hyperlink to individual text in a cell — Smartsheet Community

The only solution I have is inelegant, using JOIN in your link column with helper columns to add the display text for each link to each helper column. I don't know how many links you'll need per cell, but if it's only 2 or 3 it could be a functional solution until you find something better.

=JOIN([URL Helper Column 1]@row:[URL Helper Column X]@row, " ")

if you want a carriage return to separate your links you'll need an additional helper column or cell containing -carriage return-:

=JOIN([URL Helper Column 1]@row:[URL Helper Column X]@row, SUBSTITUTE([Helper cell/column reference], "-",""))

Hope this helps!

SSFeatures

@AdamSYNH Excellent answer!

A slight improvement to make the carriage return/line breaking easier is to use the "CHAR(10)" placeholder, which will add line breaks in between each item when joining.

=JOIN([URL Helper Column 1]@row:[URL Helper Column X]@row, CHAR(10))

For example:

You can use the CHAR function to add any ASCII characters into your formula.

Best!

Gaurav Chauhan

Thank you @AdamSYNH for the solution in here.

Since the idea is to have Users update the cells and then it reflects on the Dashboard

I see that using metric widget doesn't pull the content as a weblink but just as plain text. So once it appears on dashboard, a user cannot click on it and access it.

You are limited to using shortcut widget only.  Is there a workaround.

Please suggest as well.

AdamSYNH

Hi @Gaurav Chauhan

Without knowing how you want to structure your dashboard it is difficult to answer, but if you're able to create a report focused specifically on the column containing the links and whatever identification columns you need to place that information in context the links should pull through the sheet, report and dashboard. See example pasted from the Formula Handbook Template:

AdamSYNH

@SSFeatures Thank you for improving my answer! So glad to have learned something here too :)

SSFeatures

@AdamSYNH You're welcome! :D