Two-way street for updates between two sheets

Travis.Clair

I have two sheets used by different people. Management uses one and developers use another. Basic data being tracked is the same between the two but the one the developers manage contains technical information that management doesn't want. I run an automation so when new lines are added to the technical tracker are added the management tracker. Based on a unique identify for the each row, I run a data mesh so data on the technical sheet updates the management tracker. I need a two-way street for updates. If one of the common fields between the two sheets is updated by management on the management tracker, I want the update to be reflected on technical sheet.

Technical sheet > update > management sheet —— works via data mesh links

management sheet > update > technical sheet —— need a two way street for updates

Paul Newcome

I would suggest a single sheet with all columns. Then a row report for management and another row report for techs.