I have duplicated a Google sheets sheet (Sheet A) to another Google sheets sheet (Sheet B). I am trying to duplicate any changes in Sheet A to Sheet B. This seems like it would be super easy but I am running into issues. I am able to update a single row or copy a new sheet upon changes but I just want to simply Mirror Sheet A to Sheet B.
Will someone provide a link or a provide a guide?
Thank you.
Answer
How to mirror changes in one Google Sheets spreadsheet to another?
Best answer by Troy Tessalone
Hi
One workaround would be to use an IMPORTRANGE formula in the GSheet: https://support.google.com/docs/answer/3093340?hl=en
NOTE: This depends on whether the data in both GSheets should be editable.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
- Answer
Hi
One workaround would be to use an IMPORTRANGE formula in the GSheet: https://support.google.com/docs/answer/3093340?hl=en
NOTE: This depends on whether the data in both GSheets should be editable.
Do you think any solution in zapier would keep formatting?
Thank you again.
+14- Zapier Orchestrator & Solution Partner
What sort of formatting are you referring to?
Perhaps provide examples.
Thanks again for all of your help. I have been able to navigate around it with conditional formatting, I was just hoping formatting would copy over as well as to only have to setup conditional formatting in one place.
Thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.