formula to pull in sheet link from another sheet

MarkCep
MarkCep ✭✭✭✭
edited 02/14/24 in Formulas and Functions

Currently when I write a formula to pull data from another sheet, all works fine.

But I want to pull the Sheet link from another sheet, it only brings in the text for that cell with the hyperlink link and not the hyperlink as it is in the other sheet.

I have been doing each cell individually to hyperlink another sheet, but this seems too time consuming, but may be the only option?

Suggestions?

Thanks

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!