Google Sheets, two-way sync between range sets (same document, separate sheets)!
Budget: $30 – $250 USD
Basically, I'm looking to find out if there's a formulaic or script solution to sync between two data sets existing within the same document but on separate sheets.
This is a social media content calendar planner. I've created Checklists for each month - tasks for social media managers to accomplish re: the month's content planning, scheduling, etc... I've also created a separate sheet that contains a Gantt Chart. This would contain a master-list of all of the checklists across each month and platform.
Instead of ImportRange, however, I'd like to see if there's a possibility to create two-way syncs between the sheets. That way, any edits to the monthly checklist will be reflected on the Gantt Chart, and vice versa.
I was looking into combining the Query and Import Range function to accomplish this. I was also looking into utilizing an OnEdit Script, but I'm not versed in script work AT ALL.
I've attached screenshots, with the ranges in question highlighted in orange.
Would love to see if this is possible!
Many Thanks,
Katie
This is a social media content calendar planner. I've created Checklists for each month - tasks for social media managers to accomplish re: the month's content planning, scheduling, etc... I've also created a separate sheet that contains a Gantt Chart. This would contain a master-list of all of the checklists across each month and platform.
Instead of ImportRange, however, I'd like to see if there's a possibility to create two-way syncs between the sheets. That way, any edits to the monthly checklist will be reflected on the Gantt Chart, and vice versa.
I was looking into combining the Query and Import Range function to accomplish this. I was also looking into utilizing an OnEdit Script, but I'm not versed in script work AT ALL.
I've attached screenshots, with the ranges in question highlighted in orange.
Would love to see if this is possible!
Many Thanks,
Katie