I'm hoping to create a hyperlink from a symbol (R,G,Y) within a sheet or report for our SLT but am unable to create a functional hyperlink. For example, if the status is red, one can click the red dot and it will take them to the project dashboard for that specific team so they can delve deeper into the cause for the red status.
Obviously, I could use a widget and set it to open the dashboard but that's not a practical option for this purpose.
Is this function not available?
Help Article Resources
Check out the Formula Handbook template!