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.
but it does remove all formatting. :(
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.