I asked a similar question on the Google Support Forum. I was wondering how I could reference a cell with any sort of value in it to another sheet (inside the same Google Sheets document) and then make it so I could edit the reference cell and have it edit the original cell as well.

You can already edit the original cell and see the updates on the reference cell. But how could I have it work the other way around? I am aware that I would need a script, so could anyone help with such a script?


Not sure if the script would help, because this task is not doable in Google Sheets. Referencing referenced reference is a pure paradox and it's way beyond circular dependency which is able to be resolved up to some level.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.