I have a dashboard widget that contains a hyperlink to a form. There is a connected access sheet that we use to create individual hyperlinks for multiple clients using a query string. Currently I am copy/pasting the hyperlink from my access sheet into my dashboard widget. Does anyone know if it is possible to link the hyperlink to the cell in the access sheet? I'm trying to eliminate the need to edit the hyperlink on the dashboard every time it changes in the access sheet. Thank you in advance for any suggestions.
Help Article Resources
Check out the Formula Handbook template!