Can I use formulas to pull in hyperlinks from other sheets?

Diane Forbes

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?

Andrée Starå

@Diane Forbes

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!

Andrée Starå

Hi @Diane Forbes

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!

Diane Forbes

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

Andrée Starå

@Diane Forbes

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!

Diane Forbes

@Andrée Starå ,

Thanks, I thought that might be the case. I'll submit a feature request.

Andrée Starå

@Diane Forbes

Excellent!

You're more than welcome!