Based on community articles, I am confused if the Hyperlink function exists or not.
Regardless, here is what I am trying to accomplish.
In the roadmap tracking sheet, I have a column "Assigned Team". Each team has a workspace with top level workstream tracking (and intake process) and folders per project. What I want to add - when the team is selected in that column, to set the link to team's folder.
Teams come and go, so I plan to have a nomenclature sheet which would maintain a name of the team in one column and a link to team's folder in another column. I can use VLOOKUP to take link to a team folder upon selecting assigned team. But I cannot figure out how to make the link be a clickable hyperlink.
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!