IF level@row = X, Display short version of dashboard link, else calculation
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
Best Answer
-
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.
Answers
-
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.
-
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
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!