I'm maintaining some multi-project dashboards and running into some problems with dynamic cells.
Currently we have "Metrics" documents for each project. These documents contain cells that link to our timeline documents. For example: A cell may contain Phase I Health Status - and the cell value links to the Phase I health line in the timeline document.
That works well for single project dashboards, but for multi-project dashboards the workflow has been to copy lines from the single project Metrics pages into our mutli-project dashboard metric page.
The problem I am encountering is if I select a line in a Metrics doc and select "Copy to another sheet" - it moves the current values of the cells only, not the links.
Same thing happens if I try to manually copy cells. I also encounter an error if trying to copy many cells - apparently there is a limit of 50 cells.
Our current workflows are reliant on these Metrics documents, and being able to copy lines - and retain link information - is pretty important. Is there any way to do this?
Alternatively, is there a better workflow??
