Cell Linking Default in New Rows

T.Shuya

Hi!

I have a sheet with hyperlinks to training documents. I have another sheet which tracks when the training is completed for each person. I'm currently cell linking the training document to the other sheet but I need that cell link to be the default value when a new row is added. I tried VLOOKUP but only text appears and no hyperlink. Having the URL as a default in the Form also wouldn't work as it would require too much upkeep when the documents are updated. I have the other sheet so people can see all the documents at once and update the URLs quickly.

Thanks in advance,

Tarla

jmyzk_cloudsmart_jp

Hi @T.Shuya

To make a hyperlink that has become text by linking a cell into a clickable link, use the following formula.

="https://" + RIGHT([Hpyperlink: Cell Linked]@row, LEN([Hpyperlink: Cell Linked]@row) - LEN("https://"))

https://app.smartsheet.com/b/publish?EQBCT=a80531d6b70d47fc8311de101fca036e

jmyzk_cloudsmart_jp

Hi @T.Shuya

To make a hyperlink that has become text by linking a cell into a clickable link, use the following formula.

="https://" + RIGHT([Hpyperlink: Cell Linked]@row, LEN([Hpyperlink: Cell Linked]@row) - LEN("https://"))

https://app.smartsheet.com/b/publish?EQBCT=a80531d6b70d47fc8311de101fca036e