Hyperlink to a server (referencing cells that tell it where on the server it is)
When I use excel, I have the ability to combine several cells together using the "HYPERLINK" formula, and am able to get a link generated automatically where it will point to an outside server and folder I'm working with. Excel does it perfectly, but I'm using SS to track things within a team.
But it's 2 cells that control the entire path. The rest of the hyperlink is static, and doesn't change.
Is there a way to get SS to do the same thing?
The data in excel is like this.
Line 1, Column A = "290"
Line 1, Column B = "987654"
=HYPERLINK("\\server1\"&A1&"\"&B1&") = thus creating the link "\\server1\290\987654"
And since my team works in SmartSheet, and we're putting in the same data there, it would make life easier if SmartSheet would autogenerate that link. I've been searching, and I can't seem to find a solution to what seems like a simple problem to solve. Any ideas?
Help Article Resources
Check out the Formula Handbook template!