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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!