Enhancement Request: The ability to edit cells linked from another sheet - either directly or by double clicking and being able to edit the original sheet in a pop-up.
I have a master sheet with all of our project level data on it and engineers have individual sheets for their projects which allows them to add any kind of task tracking they want to and set their own reminders/notifications without monkeying with our entire data set. We link multiple cells to that individual sheet for them so that we can be sure they aren't making updates to dates without those updates making it into our master sheet.
I wish there was a much quicker way to edit the data in linked cells. Currently, the user has to double-click, then choose Go to Sheet, then scroll/search to the cell they want to edit, then edit, then switch tabs back to the original sheet they were working on and wait for it to reload.
Can you improve this process? Does anyone else have ideas?