Copy Rows to Someone's Shared Sheet that allows updates back / forth
Hopefully there is a possible solution to what I'm trying to do:
- We have teams who have their own project lists
- I've created a project intake form/sheet and want to set up an automation that copies the rows to their individual project lists
I know that if there's common columns across all sheets, then it'll move over fine and they can probably hide any extra columns from the source sheet.
However, is there any way for updates made to the rows that were copied to be updated on both sheets? For example, if a project is added to another list and they change the title / target end date, it'll update the same row on the source sheet?