Bi-directional sync for linked cells

Nethra Kumar · 06/23/21

Can we create a bi-directional sync between 2 linked cells from 2 separate sheets

Bassam Khalil · 06/23/21

Hi @Nethra Kumar

Hope you are fine, Cell linking always goes in one direction from Outbound cell to inbound cell.

Andrée Starå · 06/23/21

Hi @Nethra Kumar

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

There might be a possible workaround.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Harry Luk · 11/14/23

is there a product feature request I can upvote?

seems like this is a feature that's been talked about since 2015:

Bi-directional sheet linking?

Brian Bertlin

Aug 5, 2020

Is there anyway to bi-directly link two cells or rows between two sheets so if an change is made in either sheet, it is replicated to the other sheet? I found a similar question that was asked in 2015 that stated there was no way but checking if there is any new capabilities.
We have tried datamesh but it is one way from source to target similar to cell linking.

Project sheets roll up into a Program sheet, with bi-directional syncing of worksheets.

Scott_Ze1tz

May 31, 2022

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.

Formulas and Functions

Formulas and Functions

Bi-directional sync for linked cells

Answers

Bi-directional sheet linking?

Project sheets roll up into a Program sheet, with bi-directional syncing of worksheets.

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Formula - use % complete to determine whether in progress

Formula error

TRYING TO FIND THE ERROR IN THIS FORMULA