I have one master sheet (my department overview) into which I want to add links to dashboards in multiple other workspaces (one per project). I have one row per project and it is very simple to right click, add hyperlink and choose smartsheet item, then simply select the workspace and dashboard for the project.
However, I want these links to be view only and available to everyone in the organization (not just those with smartsheets). Is there a way to do this, other than going to each dashboard in turn, publishing it, copying the view only URL and pasting that into the master sheet?