Alternative to a Hyperlink


I was hoping to possibly use a hyperlink type function for my use case so it is disappointing that SS doesn't have this capability.

Does anyone have any suggestions on how to accomplish the following:

I am building a set of ISO27001 risk assessment sheets and I have a main sheet where there are different threat names listed. I have another glossary sheet that shows the same threat name and an associated description and examples. What I wanted to do was set up a mechanism where clicking on a name in the first sheet opens the second glossary sheet and highlights the row (or somehow displays the description and example from the glossary sheet). I thought that perhaps using an index to find the matching threat name in the glossary sheet would then allow me to identify the row and then I'd have a sheet name and row to somehow hyperlink from the first sheet to the correct row in the glossary sheet.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!