Is it possible to Update Cells in Both Sheets when they are Linked?

Martin T.

What we are trying to do is use one sheet as a general project breakdown (Sheet 1). Within that project breakdown is a construction schedule. We want to make a second sheet that contains all the information in the Construction schedule section of sheet 1 and turn that into its own sheet (sheet 2). I know this is possible by either Copying the rows into a new sheet or linking the cells from sheet 1 into sheet 2 but this is where the question stems from.

Is it possible to have the cells set up so that if we updated information in sheet 1 it would be reflected in sheet 2 AND if the cells were updated in sheet 2 the information would be reflected in sheet 1? In other words the information entered into the cell in either sheet being shown in BOTH sheets? Is this possible?

Best,

Andrée Starå

Hi @Martin T.

I hope you're well and safe!

Unfortunately, it's not possible now (at least not without using the Smartsheet API or similar), but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!