Is there a formula in smartsheet that would create a 2 way link between cells?


I have multiple sheets that I would like to link all into one Master Sheet. I want the cells to have a two linking methods between each other. If a cell changes in the Master Sheet, I want it to reflect to the other sheets and if the other sheet decides to change the cells, it would reflect back to the Master Sheet. The current linking method that is in Smartsheet is only a One-Way link and only allows changes from one sheet. I have noticed that there are some functions missing in Smartsheet that other programs have at our disposal.

Thank you in advanced.

Kind Regards,

Johnathon S.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!