Can I use formulas to pull in hyperlinks from other sheets?
I want to use a formula to pull in hyper-links across formulas.
I started with:
=IFERROR(INDEX({Client Intake - Client Invoice Log}, MATCH([Client Name]@row, {Client Intake - Client Name}, 0)), "")
but this only pulls in the text of what is in my client intake sheet rather than retaining the hyperlink to the sheet.
Essentially, I'm asking Control Center to populate the links to various sheets on a client intake sheet but I want to cross reference the links to individual client projects without having to re-enter them.
Anyone know if there is a way to do this?
Best Answer
-
Unfortunately, I don't think it's possible to add hyperlinks automatically outside of the blueprint.
It's an excellent idea!
Please submit an Enhancement Request when you have a moment.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Are you creating all the sheets from the Control Center Blueprint, or are they added afterward?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi @Andrée Starå,
This is a new add, so while I will be adding them with the Control Center Blueprint moving forward, I've had to manually update the rows for the projects already provisioned.
Is there a way to make the manual adds work as desired? Will the Control Center added links work as desired?
Diane
-
Unfortunately, I don't think it's possible to add hyperlinks automatically outside of the blueprint.
It's an excellent idea!
Please submit an Enhancement Request when you have a moment.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks, I thought that might be the case. I'll submit a feature request.
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!