Copying rows and updating the cell contents as changed to a back-up sheet

Mounika ✭✭✭
edited 10/25/23 in Smartsheet Basics

Hi all,

I have a sheet, which captures data as the form gets submitted by the participant. So, for this sheet (let's call it as source sheet) I would like to create an other back-up sheet (just in case if the data gets deleted or something happens unexpectedly) which stores all the data from source sheet. And if the cells are updated in the source sheet, I want the same cells to updated automatically back in the back-up sheet.

I have a tried using a "Copy a row to other sheet, when specific criteria are met", but this workflow does not seem to work in my case, as I also need the changes made in source sheet cells to reflected back in backup sheet, without having the copy of entire row again.

In a nutshell, I am looking for a workaround that would copy all cell contents from source sheet to destination sheet, and any changes/ updates made in source sheet needs to reflect back into the back-up sheet.

Can someone please help find a solution for this? Looking forward for the valuable suggestions.