Just wondering if it's possible to have 2 cells in google sheets be co-dependent.
Basically would like to accomplish the following:
If a cell in Column A is updated, then the cell in the same row of Columb B is updated with a formula
AND
If a cell in Column B is updated, then the cell in the same row of Columb A is updated with the inverse formula
Attached is an example of how we'd like to use this functionality. In the example we'd like all the blank cells to populate given the input value of the non empty cell in the same row. It shouldn't matter which cell the user inputs data, the cell next to it should auto populate.
Don't know if this can be done, but if so then would like someone to apply this to one of our google sheets.