I am looking to have sheets have a bi-directional sync between worksheets. Wanted it to be more of a Parent/Child relationship, where the Parent sheet can have 1 or more Child sheets roll up into it. While allowing the editing and syncing of each child sheet by both sheet editors. Scheduled or near real-time bi-directional sync.
The Master sheet owner can edit both Master and Child sheets. The child sheet can only edit the Child sheet.
Looking for options.