I need to have multiple Google Sheets be synced both ways.For example: I have a master sheet that has all of my information. And then I have multiple filtered sheets. Each filtered sheet only contains a subset of the master content (those rows with Jane Doe in the name column).If I edit the master sheet, the filtered sheets should update. But also, if the filtered sheet is edited, the master sheet should be updated.It seems that =importrange gets me one way (master changes, filtered updates) but it doesn't allow me to edit the content in the filtered list at all.Is there anyway to do this?
Keep multiple sheets synced (both ways)
google spreadsheets;google apps script