How to get data to flow from one sheet to other sheet and vice versa

Tasneem

I have 2 sheets which have project related details. Some of details from Sheets 1 are same as of Sheet 2.

so what i want to do is when i change any details in Sheet 1, it should reflect in Sheet 2 and also when made changes in Sheet 2 it should reflect in Sheet 1

Can anyone help in this?

Naeem Ejaz

Yes — you're describing a two-way sync between two Smartsheet sheets. While Smartsheet doesn't natively support real-time two-way syncing, you can achieve this using a combination of tools and methods depending on your plan and available features.

If you only need a few fields synced:

• Use cell linking to manually link values from one sheet to the other
• Not scalable for lots of rows or full-sheet syncing

Tasneem

Yes I need the sync for full sheet (columns) which is not quite easy/scalable by using Cell linking.

Could you please explain the combination of tools which can be used?

Paul Newcome

If you combine both sheets into a single large sheet, you can use separate reports to show each of the different column sets required.

Users would work in the reports instead of the sheets, and all data would be synced.

Tasneem

It is mandatory to have 2 separate sheets in the project . Any other way where this can be achieved without combining data and manually create cell link for the entire sheet?

Vivien Chong

If you are trying to sync the same cell bi-directionally, I think it may not be possible in Smartsheet…