I have duplicated a Google sheets sheet (Sheet A) to another Google sheets sheet (Sheet . 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.
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.
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.