Dynamic view not allowing edits for cells liked from another sheet

Alex Hackford

I am using a sheet called Global Rollup to aggregate project status across my portfolio. Each project is added to the global rollup as an individual line item and data is linked into the Global Rollup from individual Project Summary Sheets. I enabled dynamic view in hopes of being able to update certain columns (like RAG justification, get-to-green actions, and leadership asks) during portfolio reviews directly on the global and have it pushed back to the source sheet without having to go into each project summary sheet. I'm finding that those columns are not editable in dynamic view though. Is that a limitation of that view or have I missed a configuration somewhere while setting it up? You can see in my screenshot that there are several fields greyed out when I open the details panel.

Darren Mullen

@Alex Hackford Correct, if the cell is an inbound cell link, you can't edit it from Dynamic View or a report. Now, what you could do is create a report that has the individual project summary sheets, then you could edit those through Dynamic View.

Alex Hackford

Thanks for the response @Darren Mullen. Unfortunately we have upwards of 300 active projects so linking those all into one report is not really sustainable.