IF level@row = X, Display short version of dashboard link, else calculation

Protonsponge

Hello Community,

I have a series of columns that are summarising the output of complex projects. I would like to be able to have a "Link to Dashboard" at the top of a column that is a column formula. The link would provide the end user with instant access to more detail if required.

Ideally if anyone has a solution, the link would present in short format and not the full address as as dashboard links are quite long.

I have made a demo of what I am looking to achieve - instead of "www.google.com", I would like the link to an associated dashboard presented as "Link to Dashboard"

Grateful for any ideas/suggestions,

Protonsponge

Paul Newcome

You wouldn't be able to use a shortened version. The only way to get a "clickable" link from a formula, is to have the formula output the full URL.

If that link needs to be dynamic and you don't want to have to edit the formula on each, you can have the link in a Sheet Summary field and reference that in your formula. That would still have to be the full URL though.

Paul Newcome

You wouldn't be able to use a shortened version. The only way to get a "clickable" link from a formula, is to have the formula output the full URL.

If that link needs to be dynamic and you don't want to have to edit the formula on each, you can have the link in a Sheet Summary field and reference that in your formula. That would still have to be the full URL though.

Protonsponge

Thank you very much @Paul Newcome, always there with valued knowledge.
Appreciate the suggestion, I’ll bring in via sheet summary and suffer the aesthetics🤣

thanks again

Paul Newcome

Happy to help. 👍️